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

[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

[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


"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

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

"excel novice" <excel [email protected]> wrote in message
news:[email protected]...
> 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

[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


"Ron Coderre" wrote:

> 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
>
>
> "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

[Earl Kiosterud]

Novice,

=(B2 - A2)*24

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

Earl Kiosterud
www.smokeylake.com

"excel novice" <excel [email protected]> wrote in message
news:[email protected]...
> 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