addition to start and finish times that go past midnight

Hi All,

Wondering if someone could help with adding to a formula that works for start and finish times past midnight?
I have a sheet I have been using but haven't had the need to go past midnight until now.
I have had a play around with the formula that calculates the time in column F and realise I probably would need to alter other formulas, but seem to not be able to get an appropriate formula to start off with that works. I have used a couple of the generic type formulas from here and the internet with no luck.

Attached is my spreadsheet, and would be very apprecitated if there is a solution for the formulas in column F through to column L.

Thanks for your time

Michael

perhaps you say d4-B4+if(d4-b4<0,1,0) and work it into your formulas

Or

=D4-B4+(D4<B4)

Hi,
Thankyou both for your replies. I'll have a look at both of these solutions.

Thankyou

Another method

=MOD(D4-B4+1,1)