I need help to make a spreadsheet to figure work times. There is a twist, because I have to subtract break and lunch time. As you can see from the attached file, I have the break and lunch times in cells F7:F9, this is because different people have different times. If the start time is before break 1 and stop time before break 1 then the time at F4 will be right, if start time is before break 1 and stop time is after break 1 then the correct time will be F4 –I7(15 minutes). At this point I keep coming up with a #value error. I also have to cover the lunch break and break 2, with starting times all though the day. This is to keep track of time on different work orders and break and lunch times are not included in the total time per job. As I have said before, I’m self taught and my teacher is an idiot so any help will be very much appreciated.
Bookmarks