Weekend differential on time sheets

[megancoleman920]

Hello,

Is there a way to solve for weekend hours on a timesheet? We are on a 24 hour schedule and employees get paid an additional amount for weekend hours (from 12:00am on Saturday through 11:59pm on Sunday). Some employees work their entire shift during this time frame, but some straddle the window. For example, one employee works from 7pm on Friday to 8:30am on Saturday, so they should only get 8.5 hours of weekend pay. I have a sample spreadsheet attached. Any thoughts/advice would be helpful!

Thanks,
Megan

[XLent]

Megan, it's not immediately obvious where you want the calcs to go etc, however - to illustrate concept -- using your "Default" tab

Please Login or Register  to view this content.

column G will calculate hours worked on weekdays and H will calculate the remainder, which must be weekend.

it's not clear from which of the two values the 0.5 would be deducted (where appl.}