Forum Discussion

AI14's avatar
AI14
Helper III
3 years ago

time difference between static time and now time

Hi

 

i have a static start time of 05:30 and i want a measure to count the hours from then (actual)

 

ege

 

if the time is 1030 (5 hours difference) i want it to return 5

 

and if the now time is 11:44 i want it to calculate the correct difference

 

thanks

1 Reply

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi AI14 

    not sure if i fully get you, you may try to create a calculated column like this:

    Duration = 
DATEDIFF(
    TIME(5,0,0),
    [Time],
    HOUR
)

     

    it worked like: