How do I calculate elapsed hours?
 

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

http://www.cpearson.com/excel/datetime.htm#WorkHours

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"was035" wrote in message
...
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

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)?

"was035" wrote:

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