AnsweredAssumed Answered

Complex (at least for me) Time Clock Timesheet (Union Rules)

Question asked by RyanYoung on Jan 6, 2015
Latest reply on Jan 8, 2015 by philmodjunk

Title

Complex (at least for me) Time Clock Timesheet (Union Rules)

Post

Hello world!

 

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.

 

Many thanks!

 

-Ryan

ryan at soundforfilmandtv dot com

Screen_Shot_2015-01-06_at_5.13.52_PM.png

Outcomes