How to display 5.5 hours instead of 5.30 when adding \ subtracting

E

excel novice

when adding or subtracting times (13:00-08:30) how do i get the answer
formatted to show answer as 4.5 instead of 04:30
 
R

Ron Coderre

Try formatting the result as NUMBER, instead of Date or Time.

Format>Cells>Number tab
Category: Number
Decimal Places: 2

Does that help?

***********
Regards,
Ron
 
B

Bernard Liengme

If 4:30 is in A1, then use =A1*24 and format the cell as Number with 2
decimals
Excel keeps time as a fraction of a day.
 
R

Ron Coderre

Of course, without converting the time value to a proper decimal value, as
Bernard suggests, my suggestion to only change the number format does
absolutely nothing to resolve your issue.

***********
Regards,
Ron
 
Top