Hi,

Ahh...

What I want maybe didn't explain properly(usual). I have a drop down
box in a cell to say if it's a Bank Hol and it automatically calc's
that day as a normal hour working day, when I don't add the time in and
out but I want it to calculate if it's a bank hol the hours put in if is
worked...

I have attached what I've been working on if anyone can help


+-------------------------------------------------------------------+
|Filename: Opt Time Sheet.pdf |
|Download: http://www.excelforum.com/attachment.php?postid=5044 |
+-------------------------------------------------------------------+

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