How to Calculate When a Higher-Priority Call Overtakes Another in Excel
Question details
The user needs to calculate the exact time (in whole seconds) it takes for a newly arrived, higher-priority call to accumulate enough points to overtake a call that is already waiting in the queue.

- Product
- WPS Spreadsheet
- Device & OS
- not provided
- Scenario
- Managing call queues or prioritizing tasks where different items earn priority points over time at different rates.
- Observed behavior
- A mathematical formula is needed to divide the existing point difference by the new call's points earned per second, ensuring the final result rounds up to the next whole second.
Ensure you have the current points of the waiting call, the starting points of the new call (usually zero), and the rate at which the new call earns points per second.
Use the ROUNDUP Function to Calculate Overtake Time
Apply the ROUNDUP function to divide the point difference by the points earned per second, ensuring the result is in whole seconds.
The most accurate way to determine when a new call overtakes a waiting call is by calculating the point deficit and dividing it by the new call's point accumulation rate. Because time in this context is usually measured in whole seconds, using the ROUNDUP function guarantees that the calculation correctly accounts for fractional seconds.
Click on the cell where you want to display the calculated overtake time (in seconds).
Type the formula: =ROUNDUP((ExistingPoints - NewCallStartingPoints) / NewPointsPerSecond, 0).
For example, if the waiting call has 1,800 points and a new Very High-priority call earns 1,000 points per second (starting at 0), type =ROUNDUP(1800/1000, 0).
Press Enter to execute the function. In this example, the formula evaluates 1.8 and rounds it up, returning exactly 2 seconds.

Set Up a Dynamic Priority Comparison Table
Build a structured table to automatically calculate overtake times for various priority levels and scenarios using cell references.
Calculate Complex Queue Logic Effortlessly with WPS Spreadsheet
WPS Spreadsheet provides comprehensive support for logical and mathematical functions like ROUNDUP, making it the perfect tool to manage call queue logic, priority points, and dynamic calculations.
- 1. Open WPS Spreadsheet: Launch WPS Office and select Spreadsheet to create a new workbook.
- 2. Set Up Your Data: Organize your call priority data, including existing points and accumulation rates.
- 3. Apply the Formula: Type the =ROUNDUP formula into the desired output cell to instantly get your overtake time.
- 4. Save and Share: Save your document in .xlsx format for seamless sharing and compatibility across teams.

Frequently Asked Questions
Why should I use ROUNDUP instead of standard ROUND for queue timing?
The ROUNDUP function ensures that even a fraction of a second required to surpass the points is counted as a full second. This is standard practice in call queuing systems to guarantee the priority threshold has been definitively crossed before action is taken.
What happens if the new call earns fewer points per second than the waiting call?
If the new call earns points at a slower rate than the waiting call, the math will yield a negative or infinite time, meaning it will never overtake the waiting call. You should ensure your logic or table structure accounts for this condition.
Can I use this same formula for task prioritization instead of calls?
Yes, the identical formula =ROUNDUP((ExistingPoints-NewTaskStartingPoints)/NewPointsPerSecond, 0) can be applied to any queue management system, including IT support tickets, manufacturing tasks, or server requests.




