Formula for calculating target hours against actual hours
Hi,
Am Wed, 5 Jun 2013 17:20:16 +0100 schrieb Bootface:
150 target hours over 52 weeks
250 target hours over 52 weeks
208 target hours over 36 weeks
202 target hours over 35 weeks
214 target hours over 37 weeks
write your years target in E2 and write in A1 only the number of weeks
you want to work
E.g. you write in E2 214 and in A only 1 to 37, then change your
formula in B2:
=$E$2/COUNT(A2:A61)
and in B3:
=IF(C2="",B2,($E$2-SUM($C$2:C2))/COUNT(A3:$A$61))
Or have a look for your workbook in SkyDrive
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|