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

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"Cherilou" wrote:


Help!!! I can't workout how to do an overtime calculation if a standard
day was 7.5 hours (7 1/2 hours) and they work on a bank hol I want it to
state that they have worked double time in hours worked that day??


--
Cherilou
------------------------------------------------------------------------
Cherilou's Profile: http://www.excelforum.com/member.php...o&userid=36371
View this thread: http://www.excelforum.com/showthread...hreadid=561540