Examples
Examples
Try the starting example
- Requisitions: ID, opened, approved, sourcing finished, offer issued, accepted; fixed-offset YYYY-MM-DDTHH:MM
- R1,2026-10-01T09:00,2026-10-01T13:00,2026-10-02T13:00,2026-10-05T13:00,2026-10-06T09:00 R2,2026-10-01T09:00,2026-10-01T11:00,2026-10-01T15:00,2026-10-02T11:00,2026-10-02T13:00
- Elapsed basis: business or calendar
- business
- Business windows: weekday Monday 1 to Sunday 7, starts HH:MM, ends HH:MM
- 1,09:00,17:00 2,09:00,17:00 3,09:00,17:00 4,09:00,17:00 5,09:00,17:00
- Excluded business dates, comma-separated, or none
- none
- Mean phase hours: Approval, Sourcing, Offer, Decision
- Approval: 3; Sourcing: 6; Offer: 6; Decision: 3
- Elapsed time-to-fill by requisition (hours)
- R1: 24; R2: 12
- Mean observed time-to-fill (hours)
- 18
- Phase(s) with largest mean elapsed time
- Sourcing, Offer
- Sum of completed requisition elapsed hours
- 36
Try another scenario
- Requisitions: ID, opened, approved, sourcing finished, offer issued, accepted; fixed-offset YYYY-MM-DDTHH:MM
- R1,2026-10-01T09:00,2026-10-01T13:00,2026-10-02T13:00,2026-10-05T13:00,2026-10-06T09:00 R2,2026-10-01T09:00,2026-10-01T11:00,2026-10-01T15:00,2026-10-02T11:00,2026-10-02T13:00
- Elapsed basis: business or calendar
- calendar
- Business windows: weekday Monday 1 to Sunday 7, starts HH:MM, ends HH:MM
- 1,09:00,17:00 2,09:00,17:00 3,09:00,17:00 4,09:00,17:00 5,09:00,17:00
- Excluded business dates, comma-separated, or none
- none
- Mean phase hours: Approval, Sourcing, Offer, Decision
- Approval: 3; Sourcing: 14; Offer: 46; Decision: 11
- Elapsed time-to-fill by requisition (hours)
- R1: 120; R2: 28
- Mean observed time-to-fill (hours)
- 74
- Phase(s) with largest mean elapsed time
- Offer
- Sum of completed requisition elapsed hours
- 148
Calculation method
Calculation method
Mean phase hours: Approval, Sourcing, Offer, Decision
Measure adjacent supplied phase timestamps under the chosen elapsed clock, then average each phase across completed requisitions.
Elapsed time-to-fill by requisition (hours)
Sum sequential phase durations for each requisition.
Mean observed time-to-fill (hours)
Average completed requisition elapsed times.
Phase(s) with largest mean elapsed time
Compare mean phase times, retaining ties.
Sum of completed requisition elapsed hours
Sum observed time-to-fill across requisitions, not calendar resource hours.
Symbols and units
- a
- Requisitions: ID, opened, approved, sourcing finished, offer issued, accepted; fixed-offset YYYY-MM-DDTHH:MM
- b
- Elapsed basis: business or calendar
- c
- Business windows: weekday Monday 1 to Sunday 7, starts HH:MM, ends HH:MM
- d
- Excluded business dates, comma-separated, or none
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- A completed-requisition elapsed-time decomposition on supplied sequential timestamps. It excludes ongoing requisitions and does not measure recruiter effort. Business time uses fixed-offset windows, supplied holidays and no DST conversion.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.
Further reading
ILO: supplied workforce records and full-time-equivalent measurement background ↗
Background reading; this does not imply endorsement or independent review of SumFizz.