I am not as savy with Excel as I would like to be and could really use some help. I am attempting to create a spreadsheet with the total hours worked per day/week for each employee. I need help in figuring the hours per day while deducting the total taken for lunch. The amount of time used for lunch varies with each employee. We work only day shift hours and do not use military time. I have attached the spreadsheet to show what I am trying to accomplish. Any help would be greatly appreciated as I have spent too many hours trying to figure this out.
Bookmarks