David, thank you very much for the help. That worked just great. I
appreciate everyones help.

"David Biddulph" wrote:

Format the cell with the total as [h]:mm, and it will change from 1.2 to
29:00.
--
David Biddulph

"SC_Dave" wrote in message
...
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!