Help with overtime calculation

Danie3107  why not just do similar to what you already are doing and add the incremental additional pay for those hours.  In your example 7am-2am they are paid reg amt for 19 hours + delta for reg overtime for 7 hours (7pm - 2am) + delta for night overtime for 2 hours (12 - 2),  (BTW 7am - 7pm is 12 hours not 10 but we'll go with this as an example).  So lets say they get $10/hr (because actors are terribly under paid) and reg overtime is +20% so $12/hr and night overtime is +30% so $13/hr.  So in this case the formula is 19hrs*$10/hr + 7hrs*$2/hr + 2hrs*$1/hr.  Now you can combine terms and such in different ways to make the actual formula easier, for example you can:

= ( [total hours] + [all OT hrs]*[OT rate] + [night OT hrs]*[night OT rate - reg OT rate]) * [reg pay rate]

Hope that helps.