time difference between static time and now time

[AI14]

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

[FreemanZ]

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: