Help

Finding the duration between two date and time fields

Topic Labels: Formulas
Solved
Jump to Solution
2812 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Wayne_Merlino
6 - Interface Innovator
6 - Interface Innovator

Hi,

I have a time and date stamp being created in a field (Last Modified Time) for a field that we use to say when an Estimate can be made - sort of a “Clock starts ticking Now!” timestamp. The original field that the Last Modified is watching is filled by a Zapier workflow.

I then have a second field that gets time and date stamped (Last Modified Time) with when we check a box for when a user says the Estimate is done.

Lets say the 1st field has a date and time stamp of 8/1/21 2:30 pm, and the second field has a time stamp of 8/2/21 3:34 pm. How do I calculate the difference between the two? The goal is 48 hrs, so if the total came out as hours I would be fine with that. I currently have tried the following formulas but it seems to be related more to the fomatting allowed by AT but that is just a guess. Here is what I tried:

DATETIME_DIFF({Time Stamp on Estimate Checked}-{Time Stamp - Start Time})

also tried:

{Time Stamp on Estimate Checked}-{Time Stamp - Start Time}

x

Any help would be appreciated.

1 Solution

Accepted Solutions
Databaser
12 - Earth
12 - Earth

Hi @Wayne_Merlino

The formula should be formed with commas instead of “-”.

Try:

DATETIME_DIFF({Time Stamp on Estimate Checked},{Time Stamp - Start Time}, "hours")

More info.

You can then nest this formula into an IF statement.

PS: also check out the native “time tracker app”.

See Solution in Thread

3 Replies 3
Databaser
12 - Earth
12 - Earth

Hi @Wayne_Merlino

The formula should be formed with commas instead of “-”.

Try:

DATETIME_DIFF({Time Stamp on Estimate Checked},{Time Stamp - Start Time}, "hours")

More info.

You can then nest this formula into an IF statement.

PS: also check out the native “time tracker app”.

That worked perfectly! Thank you! I will also check out the time tracker app.

Great :slightly_smiling_face: Would yo mind marking my comment as the solution to your question? This helps others who may be searching with a similar question.