Calculate hours and minutes between times when it goes past midnig

G

Guest

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

Guest

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
 
G

Guest

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
 
G

Guest

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

Guest

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
Formula used to calculate daily employment hours ... 1
Time Calculated minus breaks & lunch 2
REQ: time and hours minutes calculations 1
Calculate between start and end times 2
Calculating business hours between start and stop time 3
trouble with calculating wages to hours worked 3

Top