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