http://www.cpearson.com/excel/overtime.htm

try this

hth
regards from Brazil
Marcelo

"Cherilou" escreveu:


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