Complex (at least for me) Time Clock Timesheet (Union Rules)
I'm trying to create a work sheet that performs many functions. This is for a union job so I have to calculate all these "nonsense" rules. The couple I'm having most trouble with are the following:
- Night Premium 1: Time worked between 8:00 PM and 1:00 AM are paid +10% scale
- Night Premium 2: Time worked between 1:00 AM and 6:00 AM are paid +20% scale
I have 5 sets of "Time In" and "Time Out" depending on the type of day I have. However, I need to calculate how much time is worked between those two "Night Premium" ranges so that I can calculate the appropriate payment.
I'm also having trouble with the rollover into the next day. I can upload the entire file if someone would be so kind to dig deeply into it. I can explain all of the other functions as well.
ryan at soundforfilmandtv dot com