Overtime Analyzer
Recorded overtime by person, team and week, with the people actually working it shown beside the average that hides them.
Reads .xlsx and .csv inside your browser. Nothing is uploaded.
The overtime
Drop a spreadsheet here
One row per person per day or week, with the overtime hours recorded. An employee ID, a date and the hours are all it needs; a name, team and cost help.
The average describes almost nobody
“Overtime is running at about two hours a person a week” is a comfortable sentence, and it is usually made of a handful of people working ten or fifteen hours a week and most people working none. The average is the one figure that cannot show that, so the tool puts it beside the share of all overtime worked by the top tenth of people. When that share is high, the risk is not the budget. It is a small group heading for burnout, and a team that stops working when one of them is off.
A spike is not a habit
Overtime at month end or in peak season is the job flexing, which is what overtime is for. The same person working it nearly every week of the year is different: a role bigger than the hours it is scheduled for. So each person’s overtime is counted in weeks as well as hours, and anybody working some in most weeks is named, with the bar for “most” yours to set.
Overtime is people you did not hire
The hours are also converted into full-time people, at a year’s hours you choose. It is arithmetic rather than a case for hiring, since overtime is often cheaper and more flexible than another person, but it is the form of the number a budget conversation understands.
What timesheet exports get wrong
The same row exported twice doubles that person’s overtime for the day, so exact repeats are counted once and reported. A week missing from the export looks exactly like a week nobody worked late, so gaps are listed. “1.30” means an hour and a half in some systems and an hour and eighteen minutes in others, and a column that looks like the first is flagged. And an hours column holding every hour worked, rather than only the overtime, is caught before it turns your whole workforce into people working forty extra hours a week.
What this does not do
It counts overtime that was recorded. It does not decide who is entitled to overtime, whether anybody is classified correctly, how overtime should be paid, or whether any hours worked were within the rules that apply to you. Those depend on role, location and contract, and they are questions for your payroll, legal or employment specialists. For time off rather than time on, the Absence Analyzer does the same kind of job for absence records.