Hi all, I'm working on this timesheet project where I have to separate the hours an employee works because he gets paid at a higher rate during certain hours. The timesheet separates them into hours worked from 15:00 to 23:00 and hours worked from 23:00 to 7:00.
Is there a formula to separate the number of hours on the timesheet into these categories? I've highlighted the numbers that I want to get in yellow. I've included an attachment showing what I mean.
Bookmarks