Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate hours just can't figure it out | Excel Worksheet Functions | |||
calculate hours on work sheet | Excel Worksheet Functions | |||
calculate difference in time to hours | Excel Worksheet Functions | |||
calculate average hours and minutes | Excel Worksheet Functions | |||
calculate average hours worked | Excel Worksheet Functions |