hrs. and min. between two times

asyamonique

Well-known Member
Joined
Jan 29, 2008
Messages
1,107
2:00 PM1:25 AM3hrs.25min.

<tbody>
</tbody>

Hello,
Could you help me with above sample.
I need a formula to show total hrs. between 2 times after 8 hrs extra working
Many thanks
 
Last edited:

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

CalcSux78

Well-known Member
Joined
Oct 15, 2013
Messages
1,120
You will need to apply a custom formatting such as: [h]"hrs."mm"min."

Excel 2010
ABC
114:001:253hrs.25min.

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1

Worksheet Formulas
CellFormula
C1=IF(A1>B1,1+B1-A1,B1-A1)-TIMEVALUE("8:00")

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,777
Hi

Another option:

=MOD(B1-A1+1,1)-"8:00"
 
Last edited:

asyamonique

Well-known Member
Joined
Jan 29, 2008
Messages
1,107
Thanks,
But when I drug the formulas down if cells are empty it shows like #########
Any idea?
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,746
Office Version
2010
Platform
Windows
=if(count(a1:b1) = 2, mod(b1-a1,1)-"8:00", "")
 

Watch MrExcel Video

Forum statistics

Threads
1,099,081
Messages
5,466,528
Members
406,484
Latest member
kaksolver

This Week's Hot Topics

Top