@jcsireporting asked me how to calculate time to fill when you’re dealing with many openings on 1 requisition. Here’s a quick way to work that out:
- The one requisition will have an approved “open” date of some sort. I usually like using the date that a recruiter can actually start recruiting for the job. Try not to use the time between request of req and the approval of the req – that time is helpful for segmented time to fill, but not a simple time to fill.
- When you’re working out time to fill, treat each hire as 1 row in a time to fill report. So, if you have 3 openings on 1 req, then your report will have 3 rows.
- Take the hire date – open req date for each requisition.
- Repeat for each row
Without making a table… take this example:
Req date open = 1/1/2009
Date of first hire = 1/31/2009
Date of Second hire = 2/1/2009
Date of Third hire = 2/2/2009
TTF (1) = 1/31/2009 – 1/1/2009 = 30 days
TTF(2) = 2/1/2009 – 1/1/2009 = 31 days
TTF(3) = 2/2/2009 – 1/1/2009 = 32 days
Then take the average of all of your rows, including these 3 rows…
Hope that helps!