Time Study Audit Based on Range of Employees

[LERICE84]

A colleague is trying to do a time study on how long it should take to hire a new associate. Their spreadsheet data is below. I need to enter a formula C1 to predict the amount of time it would take to hire a group of associates. We assume that 1-3 associates takes the same amount of time, and after every group of 3 associates the time should multiply by the same factor. So, if I entered 6 associates into the constant cell, I would assume that it should take 4 minutes to assemble the folders. What formula should I enter to achieve my desired result?

[TABLE="width: 1157"]
<colgroup><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD="colspan: 4"]Onboarding Time Study (Current State)[/TD]
[TD]Number of Associates[/TD]
[/TR]
[TR]
[TD]Activity[/TD]
[TD]Time (Minutes)[/TD]
[TD] [/TD]
[TD]Notes[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Printing Docs[/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD]Faster when documents are already in order[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]Assembling Folders[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]Creating Terms of Employment/Offer Letters[/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Preparing Training Room[/TD]
[TD="align: right"]10[/TD]
[TD] [/TD]
[TD]Ensuring computers are plugged in and have access to the right websites[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Checking Associates In[/TD]
[TD="align: right"]15[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]Conducting NHO[/TD]
[TD="align: right"]45[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]Signing Docs at NHO[/TD]
[TD="align: right"]45[/TD]
[TD] [/TD]
[TD]Depending on languages[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]Completing WOTC and I-9[/TD]
[TD="align: right"]24[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]48[/TD]
[/TR]
[TR]
[TD]Post NHO signature verifcation[/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Gathering Docs for File[/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Send out New Hire Email[/TD]
[TD="align: right"]8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]Fill out information on the New Hire Form for Payroll[/TD]
[TD="align: right"]15[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]Creating Discount Card[/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Creating the Files and Tabs[/TD]
[TD="align: right"]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]Filing New Hires Folders[/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Update New Hire Log[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]Update Audit Log[/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]Complete 2nd portion of I-9[/TD]
[TD="align: right"]20[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Total Minutes[/TD]
[TD="align: right"]223[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]338[/TD]
[/TR]
[TR]
[TD]Total Hours[/TD]
[TD="align: right"]3.716666667[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]5.633333333[/TD]
[/TR]
</tbody>[/TABLE]

 

[mrshl9898]

If 1-3, 4-6 etc are the breaks then:

=ROUNDUP(constant cell/3,0)

Will turn 1-3 to 1 4-6 to 2 etc.

Then just multiply by the time

 

[LERICE84]

If 1-3, 4-6 etc are the breaks then:

=ROUNDUP(constant cell/3,0)

Will turn 1-3 to 1 4-6 to 2 etc.

Then just multiply by the time

Thanks- this worked!