Hello everyone,
I have a problem that I've been trying to figure out the best way to solve it and have not been successful. I'm hoping that one of you amazing people would be able to assist.
I have a time sheet that includes employee’s names, in times, out times, and break times. I’m trying to create a formula that will give me the length of their shifts on any given day. Here’s the catch: It needs to be able to give me the length minus a lunch break (of 30 min) if the length is equal to, or greater than 6 hours, but if less than that, it should give me the length without the lunch break. Having said that, each shift changes every day, and if I send any one of them home early or they come in late, I will change their out time or in time in the sheet, so the length column needs to update live.
I've attached a screen shot of the file so you can see what I'm looking at.
Any ideas are more than welcome.
Thank you!
Bookmarks