# Project Staffing formula in Excel

1. Aug 12, 2008

### Sue Hughes

Greetings all -

I am trying to determine the staffing requirement for an ongoing project. Here are the project specs, and I need to know if I need a part time or full time person.

461 clients
10 minutes to complete each client task (minimum of 10 minutes)

How many hours a week would be needed to complete these 461 clients at ten minutes each. We need to repeat this quarterly.

Thank you!
Sue

2. Aug 12, 2008

### cristo

Staff Emeritus
Erm, at least 4610 minutes, or 77 hours will be the total time for 461 ten minute tasks. I'm not really sure what you're looking for, though.

3. Aug 12, 2008

### Sue Hughes

I need to tell management how many hours a quarter an employee would be working on this project.
If I had a formula in Excel, I could change those numbers of clients and numbers of minutes.

Sue

4. Aug 12, 2008

### cristo

Staff Emeritus
Ok, well there you go: 77 hours a quarter (if every slot is ten minutes precisely).

5. Aug 12, 2008

### Sue Hughes

Do you by chance have the formula I could plug into Excel for when the times and number of clients change?

Sue

6. Aug 12, 2008

### cristo

Staff Emeritus
I can't remember what equations in Excel look like (I've not used it for a very long time), but algebraically, if n is the number of hours, and m is the number of minutes each task takes, then the number of hours in total is n*m/60 (then rounded up to the nearest hour).

I guess in excel this would look something like A1*B1/60

7. Aug 12, 2008

### Sue Hughes

Excellent! I've got it. Thank you SO much!
Sue

8. Aug 12, 2008

### cristo

Staff Emeritus
You're welcome

9. Aug 12, 2008

### Moonbear

Staff Emeritus
I'm sure you meant number of clients rather than number of hours for n (the part I bolded). Just pointing it out to make sure Sue isn't confused by a typo.

10. Aug 12, 2008

### cristo

Staff Emeritus
Indeed I did mean number of clients: thanks MB!