hrs. and min. between two times

[asyamonique]

2:00 PM

1:25 AM

3hrs.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

 

[CalcSux78]

You will need to apply a custom formatting such as: [h]"hrs."mm"min."

Excel 2010

	A	B	C
1	14:00	1:25	3hrs.25min.

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

Sheet1​

Worksheet Formulas Cell Formula C1 =IF(A1>B1,1+B1-A1,B1-A1)-TIMEVALUE("8:00") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[asyamonique]

Thanks

 

[pgc01]

Hi

Another option:

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

 

[asyamonique]

Thanks,
But when I drug the formulas down if cells are empty it shows like #########
Any idea?

 

[shg]

=if(count(a1:b1) = 2, mod(b1-a1,1)-"8:00", "")

 

[asyamonique]

Thanks a lot