Calculating Time Diff (in hours) over Multiple Days

MargieDomo · April 3

Hello 😊

I am trying to write a beast mode that will calculate the time difference in hours (sometimes over a multiple day period).

For instance, if the start time is 4/1/24 at 1:00pm and the end time is 4/2/24 at 9:30am I would like the beast mode to calculate 20.5 hours.

Any help is appreciated! Thanks!

Godiepi · April 3

Try this one :

(UNIX_TIMESTAMP(`TimeStamp_1`)-UNIX_TIMESTAMP(`TimeStamp_2`))/3600

Jenna · April 3

Maybe Try TimeDiff((Most Recent Date),(Oldest Date))

Jenna · April 3

HOUR(TIMEDIFF(Verification/\nCommunication\nSent, Intake/Auth Req Received))

This returns just the hours, I tested it using data with 2 Timestamps

Godiepi · April 3

Try this one :

(UNIX_TIMESTAMP(`TimeStamp_1`)-UNIX_TIMESTAMP(`TimeStamp_2`))/3600

GrantSmith · April 3

Hi @MargieDomo - I'd recommend a beast mode like

This will allow you to calculate time differences and format it

Best Answer