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

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

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

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

FormatCellsNumber tab
Category: Number
Decimal Places: 2

Does that help?

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


"excel novice" wrote:

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

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

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.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"excel novice" <excel wrote in message
...
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

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

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


"Ron Coderre" wrote:

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

FormatCellsNumber tab
Category: Number
Decimal Places: 2

Does that help?

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


"excel novice" wrote:

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

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

Novice,

=(B2 - A2)*24

Format (Format - Cells - Number) as General, Number, etc (not date).

Earl Kiosterud
www.smokeylake.com

"excel novice" <excel wrote in message
...
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