Add and subract Time

D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top