How do I calculate elapsed hours?

G

Guest

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
 
G

Guest

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

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

Similar Threads

Time Calculated minus breaks & lunch 2
Elapse date and time 2
calculate time does not calculate 2
Access Access - Elapsed Time between Records 5
Calculate elapsed time excluding specific timeframe 10
#VALUE error add'g formulas 1
How do I calculate time in excel (clock in and clock out 3
how do I calculate times and get as a result numbers 1

Top