Excel 2003 Time Calculation

[Guest]

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

 

[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