Without seeing your sheet (hours)/(thing you want to standardise
by)*1000
So for example if hours are in A1
If number of staff is in B1
If you want hours per thousand staff in C1
Enter in C1 =A1/B1*1000
Regards
Dav
--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread:
http://www.excelforum.com/showthread...hreadid=507971