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