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!