How to calculate with days and minutes

[karimoo]

If you want to add days or minutes to a Date & Time field in a Custom Formula see:

Help : StarTIME +60 = funny Endtime

Just figured it out: If you start calculating in a formula with a date/time you will get a decimal as a result: [image]. This number represent the number of days since 01/01/1970. That means today 6/18/2020 is 18431 days past 01/01/1970. The decimal represent the fraction of time per day. If you want to add 1 day you can just calculate [image] If you want to add minutes you have to use the fraction of 1/1440 for 1 minute [image] In the Custom Formula you can add minutes like this: [im…

And here is a second one using time calculations:

Activate the purchasing services according to the opening hours: morning and afternoon

Hello everyone, I recently know Adalo and I need help. It seems to me an excellent tool but at the moment I’m going crazy to manage the activation of orders based on the opening and closing times of the restaurant. The need is simply to check on the basis of the current time if the restaurant accepts orders or not. If he accepts them, I can show the checkout button, otherwise a message informing the user that the restaurant is currently closed. Two shifts are scheduled for each day: in the mor…

[jeremy]

Thanks for collecting these together @karimoo!

[zeemis52]

Thanks @karimoo for the info.

I am trying to use the “sometimes visible”, but it does not accept formulas. Is there a workaround for this.

Basically, I just want to say “good morning”, “good afternoon”, or “good evening” depending on the time of the day.

Thanks in advance!

[Yongki]

@zeemis52

greeting based on time

Here is cloneable app that say greeting based on time

in my example, GMT+7, so the fraction need to be substracted with 7*60/1440

to calculate variable related to user, it is better doing it in the collection, then using update operation, we can have option of magic text and custom formula

change input value and sometimes visible are still very limited, so we need proxy variable, which is in users’ collection property.

I didn’t realize that checking time in app dev need intense calculation like this, probably, I used to look at the time at granted.

[tbel]

Hmm I tried this but it doesn’t appear to be working anymore?

[Yongki]

Can you give me example rather than claim ?

It has been months since first created.

[tbel]

There doesn’t appear to be a greeting

[Yongki]

This is cloneable app, you can check inside of the app.

You can play around with the fraction.

[tbel]

Yup tried, cloned it, played and not getting any greeting by default. Don’t trouble yourself too much with it, it would be a nice to have feature. But not vital

[Yongki]

What time is your test ?
Before 11:30am ?

Do you know that adding more fraction means adding time too ?

[thebiglemonski]

Only the a@a.com user has the necessary DB fields. Should work if you login as a@a.com and use ‘a’ as password or set the ‘greeting’ and ‘fraction’ DB fields for your own user.

[Matt1]

Hi @Yongki

Thank you for making this example clone

Is it correctly understood, the time is only update when the user sign in. Which should of course only happens the first time I go into the app. Any ideas for how to make this work, so that the time stamp is update on the user every time he enters the app? I tried setting this op to load when users visits Home, but I cannot get it to update the property - it only updates if I add it to another screen the user goes to actively.

Maybe you have some ideas or ways to approach this?

Thank you

[adeniyiabidemi]

Certainly! For a more automated approach, consider using an online time conversion tool. These can instantly convert days to minutes and handle all sorts of time-related calculations, which can be incredibly handy for managing project timelines. Also, for future reference when dealing with percentage changes in project timelines, I recommend using this Percentage Increase calculator. It’s a fantastic resource for quickly determining the increase or decrease in project durations or any other percentage-based calculations you might need.