TimeSheet calculatons Overnights

[Guest]

We have a shift that runs from 19:00 until 07:00 the next day. How can I get
Excel to calculate the hours without the necessity of adding a date to the
cell.

 

[Roger Govier]

Hi Don

With start time in A1 and end time in B1
=MOD(B1-A1,1)

 

[Guest]

=MOD(B1-A1,1)
or
=(B1-A1)+(A1>B1)

 

[Guest]

Start time =A1
End time = B1

Try:-

=(B1-A1+(B1<A1))*24

Mike

 

[Guest]

THanks so much, it worked great.

DOn

=MOD(B1-A1,1)
or
=(B1-A1)+(A1>B1)