Difference of start and end time in difference column (result in hours)

[akapoor03]

How can I get difference of start and end time in Difference Column-

I want the result in Hours as whole number as I need to create measure afterwards to sum the hours.

[ryan_mayu · Accepted solution]

@akapoor03 

=Hour (Endtime-starttime)

OR

=(endtime-starttime)*24

[Vera_33 · Accepted solution]

Hi @akapoor03 

If you consider decimal number, one way in M

Duration.TotalHours([End Time]-[Start Time])

and another way in DAX

DATEDIFF([Start Time],[End Time],MINUTE)/60

[ryan_mayu · Accepted solution]

@akapoor03 

=Hour (Endtime-starttime)

OR

=(endtime-starttime)*24

[akapoor03]

This is given me below output-

[ryan_mayu]

you can change the data type to whole number

[akapoor03]

perfect.Thanks

[ryan_mayu]

you are welcome