Time to Hire/Fill Calculation

Month of: ______________________

Note: Several calculations will be produced using this

template: 1) the number of days from the date

of approval to create or fill a position to the date the offer

is accepted; and 2) the number of days from the

date of approval to create or fill a position to the date

the candidate starts working. (Formulas are included.)

Formatting of cells is lost when spreadsheets are posted online. For the formulas to work in this template, you will need to format Columns C,D, and E for dates. You must also enter dates in format of month/day/year for formulas to work.

(Enter dates in format of month/day/year for formulas to work)

Position Department Date of

Approval to

Create or

Fill Position

Average time to hire/fill for the month

Formatting of cells is lost when spreadsheets are posted online. For the formulas to work in this template, you will need to format Columns C,D, and E for dates. You must also enter dates in format of month/day/year for formulas to work.

Date Offer Date Time/Days to Offer Time/Days to Fill

Is Accepted Candidate Starts Hire (Using Date (Using Date Candidate

Working Is Accepted) Starts Working)

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0.0 0.0