Calculate hours and minutes between times when it goes past midnig
 

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.

Calculate hours and minutes between times when it goes past midnig
 

A1: start time
B1: end time

C1: =B1-A1+(A1B1)


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

Calculate hours and minutes between times when it goes past midnig
 

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.

Calculate hours and minutes between times when it goes past mi
 

"Teethless mama" wrote:

A1: start time
B1: end time

C1: =B1-A1+(A1B1)


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





Thank you very much Mama. It worked great!

Calculate hours and minutes between times when it goes past mi
 

"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!

Calculate hours and minutes between times when it goes past mi
 

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!

Calculate hours and minutes between times when it goes past mi
 

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!

Calculate hours and minutes between times when it goes past mi
 

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!

Calculate hours and minutes between times when it goes past mi
 

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!

Calculate hours and minutes between times when it goes past mi
 

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!