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 tim...
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: