Calculating time difference when start time is 1 day and end time is another

[WxShady13]

I have a spreadsheet where workers can calculate downtime simply by entering the start of the downtime and the end of the downtime. This works great until it occurs before midnight and then ends after midnight. How should the formula go to account for the day? I have a start shift and end shift column also.

 

[joeu2004]

If A1 is the start time and B1 is the end time:

B1 - A1 + (B1 <= A1)

formatted as Custom [h]:mm .

The use of (B1 <= A1) and "[h]" displays 24:00 when B1=A1.

FYI, MOD(B1-A1,1) will show 0:00 when B1=A1. Not recommended.

 

[WxShady13]

Thank you!!!!