Check out Chip Pearson's site
http://www.cpearson.com/excel/overtime.htm
http://www.cpearson.com/excel/DateTimeEntry.htm

"sax30" wrote in message
...

Hi,

This is the simple version of the time sheet that I am working on and I
need help with the time calculation.

a1 b1 c1 d1
e1
Date Time In Time Out Lunch
Total hour
4/26/05 8:30 5:00 .5
8

I got in at 8:30 morning and leave at 5:00 in the afternoon. I use
half hour for lunch. So my net hour would be 8.

I want to have my TOTAL HOUR to be calculated automatically when I
enter the TIME IN and TIME OUT since my schedule is not set. The Time
In and Time Out must be in that format (8:30, 5:00. It can not be in
the 24 hr format). Thanks!


--
sax30