Calculating Time Diff (in hours) over Multiple Days

MargieDomo
MargieDomo Member
in Beast Mode

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!

Tagged:

Best Answer

  • Godiepi
    Godiepi Coach
    Answer ✓

    Hello @MargieDomo

    Try this one :

    (UNIX_TIMESTAMP(`TimeStamp_1`)-UNIX_TIMESTAMP(`TimeStamp_2`))/3600
    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'

Answers

Categories