Convert Excel time to decimal hours

[kelvin0403]

Hi, I would like to convert my time in D5 to hours in decimal point. The result should return as 1.83 hour, however, my result is 20:00. Where is the mistake in my formula?

Thank you
Kelvin

 

[arthurbr]

Nothing wrong, just format E5 as " Number"

 

[ebea]

I think you have the wrong formatting. Use standard formatting, and not hh:mm