Well for some reason it moved all my columns around. I am sorry to be a pain
but I really want to figure this out. Thanks for your help

David




"SC_Dave" wrote:

Thanks a lot. I have it working now except for one thing. The sum of my
hours in column D is formated in Military time as is the Time In and Time
Out. They are totaling fine. When I try to total the hours in D I am
getting an incorrect figure. Below is what I have now. Thank you very much
for your help on this.


Date Time In Time Out Total Supervisor Signature / Worked With
19:00 5:00 10:00
16:00 3:00 11:00
7:00 15:00 8:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00

Total Monthly Hours 1.2


"Teethless mama" wrote:

Make sure time is a real excel time not a text time
ex: 7:00PM (is not a real excel time). It should be 7:00 PM


"SC_Dave" wrote:



"Teethless mama" wrote:

Another way...

=MOD(B1-A1,1)



"SC_Dave" wrote:

IE: Time starts at 7:00PM on one day and ends at 5:00AM the next morning.
When I do it the conventional way it calculate 14 hours when in fact its 10
hours. Any help would be greatly appreciated.





I spoke too fast, Why am I getting #VALUE!