Help : StarTIME +60 = funny Endtime 🤔

Hi geeks,
I’m trying to figure out how Adding a Value to a DateTime works.
Field is set to Display TIME : ie 00:00
Formula set is :open_mouth:
StartTime +Number ( = EndTime)
00:00 + 60 = …12:34 (!!!) :thinking:

magic time

… I would expect it to be 00:01:00 or 01:00:00
(unless its 00:00:00:060)

Does anyone knows why it is returning 12:34 and how one adds a 1 (Hour/min) value to a Time correctly ?
Thanks a lot

1 Like


Good question! :blush:

1 Like

Just figured it out:
If you start calculating in a formula with a date/time you will get a decimal as a result:

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
If you want to add minutes you have to use the fraction of 1/1440 for 1 minute
In the Custom Formula you can add minutes like this:
Where Input represents the number of minutes you want to add.
And don’t miss the brackets :slight_smile:


Ma mamia Karimoo, where did you dig to uncover those secret formulas ? :smile:
Its the 1rst time i hear about this 1440 though I knew about the Epoch time reference.
This makes so much dif. now, Will test this right away…
Is this 1440 division related to the Epoch settings or that was another Coder’s creation ?
Very interesting !!!
Claping again with both hands and feet ! :smile: :clap: :clap:

1 Like

Confirming ! Karimoo your formula just solved it !
Thanks again, great method !correct time calc
Itchiban :ok_hand:

@karimoo Thanks a lot, It’s saved my time :star_struck:

Hi @bibipac
What was your final formula to get the 24hrs time format out of the datetime? I am having some trouble with this right now. Can you share it?


how do you get the fraction or decimal to return a date?

1 Like