I assume standard hours are used and you are trying to determine
variations due to leave etc. You can use 6 nested IF statements, chack
if a cell is blank, part time holiday, part time vacation etc etc and
put in the required value...


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=551373