Hallo Andy,

Am Tue, 3 May 2011 21:41:51 +1000 schrieb Andy Bolger:

formula looks great except for one thing, it puts 3 hours in even if they
haven't worked.

try this:
=IF(D5="",0,IF(OR(D5={"AL","SICK","PH"}),8,MAX((WE EKDAY(B5,2)5)*3,MOD(E5-D5,1)*24-0.5)))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2