Hello,
I'm trying to calculate hours of the same day before a break. For instance, for October 1, the break occurs at 12:30, so I'd like to calculate how many hours were worked before that break. It's complicated because there are clock-outs and clock-ins within the same minute (we have billable jobs and sometimes jobs are switched, this is why there is a clock-out and clock-in at the same time). For instance, for October 1, employee clocked out at 6:17 and back in at 6:17, so this is not a break, it's a job change.
Normal timecards would occur like October 2, which would be really easy to find out how many hours one has worked before taking their lunch break. Unfortunately, the work environment doesn't allow for such easy calculations because of the billable and non-billable jobs for our clients.
Times.jpg
I added an attachment of what one period would look like. I totally appreciate any help with this!
Bookmarks