How do I calculate elapsed hours?

W

was035

I need to know how to calculate elapsed hours.
example: start time of 1:30 PM, end time of 9:30PM equals 8 hours.

How would I factor in a 30 min unpaid lunch?
example: start time 1:30PM, end time 10:00PM equals 8 hours
 
K

Kassie

Say you have 12:30 in A5 and 22:00 in B5. In C5 enter =B5-"00:30:00"-A5. If
there is not always a lunchbreak, you will have to use an IF statement
though. Maybe something like =IF(B7-A7<"08:00:00",B7-A7,B7-"00:30:00"-A7)?
 
Top