Calculate hours and minutes between times when it goes past midnig

S

SC_Dave

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.
 
T

Teethless mama

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
 
S

SC_Dave

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
 
S

SC_Dave

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
 
D

David Biddulph

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

SC_Dave

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

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

SC_Dave said:
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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate After hours 3
Hours between to two times 3
Calculate between start and end times 2
Calculate the total overlapping time of multiple tasks, excluding non-working times 1
trouble with calculating wages to hours worked 3
Calculating business hours between start and stop time 3
Check if Time falls between ? 3
Format a TIME image in a cell 3

Top