formula help
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
|