Beast Mode

Beast Mode

Calculating Time Diff (in hours) over Multiple Days

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:

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Best Answer

  • Coach
    Answer ✓

    Hello @MargieDomo

    Try this one :

    1. (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

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In