ROUNDUP & the rounding family
Round staffing the way operations actually works.
Why planners need it
Erlang gives fractional agents; rosters don’t. ROUNDUP never under-staffs; MROUND/CEILING snap times to real shift blocks.
Syntax
=ROUNDUP(number, digits) · =CEILING(x, sig) · =MROUND(x, multiple)
Worked example
Erlang requirement is 18.3 agents. =ROUNDUP(18.3, 0) → 19 (rounding to 18 would miss SL).
Snap a 08:07 start to the nearest 15 minutes: =MROUND(start, "0:15") → 08:00.
Watch out: ROUND can round down and under-staff — use ROUNDUP for requirements. CEILING needs a significance argument, not a digit count.