Excel 2003 Time Calculation

W

WR Cheng

Hi,

I would like to know how to calculate time on Excel. For example: 8:00 AM
to 1:30 PM is 5.5 hours. How do I use excel to give me the result that I am
going for?

Thanks
 
P

Pete_UK

Assume the times are in A1 and B1 and are in Excel time format, i.e.
stored as a fraction of a 24-hour day. You can put this formula in C1:

=(B1-A1)*24

and format the cell as Number with 1 or 2 dp.

Hope this helps.

Pete
 
Top