Okay I am fairly knowledgeable in Excel; however, I cannot figure out how to calculate the following in an excel spreadsheet. I need to be able to show the calculation used in order to get the total number of hours worked for that day, since there are several "breaks" within the day. I have put the cell locations below each time to use as reference when you explain to me. Please help!!! Thank you
Total
In Out In Out In Out Hrs.
9:15 AM 10:30 AM 11:00 AM 12:00 PM 2:00 PM 5:00 PM ___?___
C4 D4 E4 F4 G4 H4 I4
Bookmarks