Time calculations in Excel 2002

  • Thread starter Thread starter Andre
  • Start date Start date
A

Andre

I need to display the result of a time calculation as a
decimal e.g. 08:30 - 08:00 = 00:30 I want the 00:30 to
be displayed at 0.5 (half an hour). Is this possibel and
how do I do it?
 
Excel stores times as fractions of a day i.e
0.00 = 00:00
0.25 = 06:00
0.999305 = 23:59

So, to get the result in hours as a decimal simply
multiply the result of your calculation by 24, then set
the number format to Number.

Cheers,
Dave
 
Back
Top