Add and subract Time

[DG]

I found a time card worksheet on-line and I don't understand the formula.
It works but even when I evaluate the formula I don't understand why.

D E F G
Start Wrk Start Lun End Lun End Wrk
8:00 AM 11:00 AM 1:00 PM 5:00 PM

The row with the times is 8.

the formula in cell H8 is =(E8<D8)+E8-D8+(G8<F8)+G8-F8

I don't understand what the (E8<D8) or (G8<F8) does?

When I evaluate the formula they both return FALSE. If I change the time so
the evaluate as TRUE it still does the math.

In fact I can take it out so the formula reads E8-D8+G8-F8 and I still get
7:00 hours.

Any help would be great.

 

[John Waller]

See http://www.cpearson.com/excel/overtime.htm

(E8<D8) or (G8<F8) allows for working past midnight i.e situations where
the finish time is earlier than the start time and no date is specified.

e.g. night shift where start=11:00pm and end=7:00am.