Start time in A1,
End time in B1,
Enter this formula in a cell formatted as "General" or "Number":
=(B1-A1+(B1<A1))*24*AND(A1<0,B1<0)


Both A1 and B1 must have times entered for this to work.

This will also work when the times span across midnight.
--


HTH,


RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"M.R.S." wrote in message
...
Hi all,

I'd like to create a simple time sheet that calculates the amount of hours
I've worked in a day.

ex:

Date Time IN Time OUT Total Hours

01/01/01 9:00AM 5:00PM 8



And so on for the week, and then have a total at the bottom for total hours
(that part is easy enough).

I've seen this done before.

Better yet, if I could figure out how to enter this data on my Visor PDA and
merge it into excel, that would be excellent.

Any suggestions?!?

Thanks.