Need more information.
- Does the Holiday Pay start at midnight?
- Does the Holiday Pay start at shift-change (for example: 11pm the night
before?)
- Does the employee need to work x # of hours on the holiday before the
Holiday Pay kicks in?
- Does the employee get Holiday Pay if the shift is mostly in the previous
day / the following day?
- Does typical OT start after 7.5 hours?
- Does typical OT start after 8.0 hours?
- Does typical OT start after 35 hours?
- Does typical OT start after 40 hours?
- Does the employee get triple pay for work after x hours [7.5 / 8.0] on a
Holiday?
That said, the simplest formula is...
Assuming the hours worked are in cell A1...
=A1x2
--
HTH,
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.