I have timesheet problem I need help with. I’ve attached a simplified example of my timesheet with five columns: A=Time In, B=Lunch/Other Out, C=Lunch/Other In, D=Time Out, E=Total Hours.
Factoring in the B and C columns is what has me stumped. Here are the conditions I need to have met:
If C-B is 30 minutes or less, ignore the value (do NOT factor it into the equation)
If C-B is greater than 30 minutes, subtract the additional minutes from the total.
Thanks in advance for your help!
Kirk
Bookmarks