Calculating Time Diff (in hours) over Multiple Days

MargieDomo

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

Hello @MargieDomo

Try this one :

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

Jenna

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

Jenna

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

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

Godiepi

Hello @MargieDomo

Try this one :

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

GrantSmith

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

https://community-forums.domo.com/main/discussion/52682/domo-ideas-conference-beast-modes-time-difference-formatting

This will allow you to calculate time differences and format it