Thread: How to display 5.5 hours instead of 5.30 when adding \ subtracting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default 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
Reply With QuoteReply With Quote