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

[learner03]

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]

@learner03 

=Hour (Endtime-starttime)

OR

=(endtime-starttime)*24

[Vera_33 · Accepted solution]

Hi @learner03 

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]

@learner03 

=Hour (Endtime-starttime)

OR

=(endtime-starttime)*24

[learner03]

This is given me below output-

[ryan_mayu]

you can change the data type to whole number

[learner03]

perfect.Thanks

[ryan_mayu]

you are welcome