Hi

i have created a staff in post excel document but i am now stuck on a formula

a full time member of staff in our office works 37 hours per week which equates to 1.00.

But we also have staff that work part year and term time i need the formula to work out to the decimal place

i can work this out manually but there are quite a few staff in the office and continually changes

manual way to do this would be:
TO WORK OUT PART TIME HOURS
26 hours (staff members part time hours) divided by 37 (the full full time weekly hours) the SIP (staff in post) would be 0.70

BUT TO WORK OUT PART YEAR AND TERM TIME
The calculation would be
someone working 30 hours per week for 37 weeks per year would be
(30 [staffs part time hours]/37 [full time equivalent hours]) x (37 [weeks they will work in the year/52 [full working year]) = 0.58 (rounded to nearest decimal place

i need a formula to work this out for me in cells H5 to H53