Project Staffing formula in Excel

[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)
Repeat each task quarterly

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

Do you need more information to get the Excel formula?

Thank you!
Sue

 

[cristo]

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.

 

[Sue Hughes]

Thank you for your quick reply Cristo

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

 

[cristo]

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

 

[Sue Hughes]

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

Sue

 

[cristo]

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

 

[Sue Hughes]

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

 

[cristo]

You're welcome

 

[Moonbear]

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

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.

 

[cristo]

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.

Indeed I did mean number of clients: thanks MB!