This post from a Reddit user struggling to track erratic, on-demand work hours captures exactly why traditional spreadsheets fail people. The request is simple: log a start time and end time, get back total hours, and have those hours automatically sorted into regular, overtime, and night-rate buckets. But the frustration in the message is real. The user does not know Excel, does not have a PC, and is trying to do this on a phone app while juggling a schedule that changes without notice. The spreadsheet, designed for fixed rows and predictable data, is fighting them at every turn.
That is not the user's fault. It is the tool's limitation. A spreadsheet is a blank grid that demands you become a programmer before you can get a simple answer. You have to learn formulas for time arithmetic, conditional logic for night-hour thresholds, and manual entry for every shift. The user here is not asking for something exotic. They want a system that understands *time* as a category, not as a number you subtract. They want to know, at a glance, what they earned for a 10 p.m. shift versus a 2 p.m. shift. And they want it to add up without them having to build the math from scratch.
The good news is that the technology to do this already exists. AI-native spreadsheets can interpret plain language like "count hours after 10 p.m. separately" and apply that rule automatically across every entry. They can recognize that a date column and two time columns should produce a calculated total without the user writing a single formula. The user does not need to learn Excel. They need a tool that treats their work pattern as the starting point, not as a problem to be solved through manual configuration.
Our take is straightforward: no one should have to wrestle a spreadsheet to get paid correctly. If your job is unpredictable, your tracking tool should adapt to you, not the other way around. The solution is not a better tutorial on Excel formulas. It is a smarter spreadsheet that understands what you mean when you say "night hours" and does the rest. For this user, and for millions of others working on-demand, that is not a luxury. It is the minimum.