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…

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

:open_mouth: Good question! :blush:

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 y…

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 Cod…

@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? Thanks!

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

Hi, I tried your formula but it’s not working for me. So, I have a form to schedule a meeting, where meetings are all 20 minutes long (to be integrated on Zapier). The starting date and time is a date picker for the user and the finishing time is currently an automatic field, being = “suggested tim…

Hi, Which format is the “Contact request suggested time”? If this is what you are working on, you can copy my template The one with Date calculation [image]

Help : StarTIME +60 = funny Endtime 🤔

Get Help

ChristopheHK June 17, 2020, 11:46pm 2

Good question!

Add Date "Manually" in "Update Record" function

Topic		Replies	Views
Is it possible to add time to an existing time on btn press? Get Help	1	1613	September 8, 2020
How to convert Unix decimal to actual time Get Help	1	755	June 23, 2022
How to calculate with days and minutes Resources & Tutorials	12	6614	November 5, 2023
The Fraction Of time External Collections, Custom Actions & Collections	5	1105	November 30, 2020
Activate the purchasing services according to the opening hours: morning and afternoon Get Help	8	3995	September 3, 2021

Help : StarTIME +60 = funny Endtime 🤔

Related topics