There's a quiet frustration buried in this spreadsheet question, and it's one we hear far too often. A user enters "6:00," "6:30," and "8:30" into cells formatted as time, then asks for a total, and gets zero. Not an error, not a warning, just a flat, unhelpful zero. The immediate workaround is to swap the colon for a comma, and suddenly the math works. But that's not a fix; that's a surrender. It means re-entering data by hand every time new hours arrive, and it means living with a system that punishes you for using time notation the way it was designed to be used.
The root of the problem isn't arithmetic, it's context. When a spreadsheet sees "6:00," it doesn't automatically think "six hours of work." It thinks "six o'clock in the morning," a point on the clock, not a duration. And when you try to sum points on a clock, you don't get hours worked; you get a time of day that resets or collapses to zero. That's why the comma trick works: "6,00" is treated as a plain decimal number, so the spreadsheet happily adds six plus eight. But that solution only works if you're willing to abandon time formatting altogether, which means every new entry becomes a manual conversion, a place where errors creep in, and a workflow that fights you instead of helping.
What this user needs, and what too many spreadsheet users don't realize they need, is a way to tell the tool, "Treat this as a duration, not a clock time." That's not a hack. That's a fundamental shift in how we think about data. In Excel, the fix often involves multiplying by 24 or using a custom format that displays hours over 24, but those are workarounds that still require the user to know the difference between a time of day and an elapsed interval. The real issue is that spreadsheet software has long assumed its users will adapt to its quirks, rather than the other way around. This is where the opportunity lies: not in teaching people to live with the zero, and not in telling them to change their data entry habits, but in building tools that understand intent.
We think the takeaway here is simple: your spreadsheet shouldn't make you choose between readable data and correct math. If you're entering "6:00" and the software knows you mean six hours, it should compute six hours, full stop. The fact that it doesn't is a design flaw, not a user error. So the next time you hit that zero, don't accept it as the cost of doing business. Push back. Look for a tool that treats time as a unit of work, not a position on a dial. And if you're stuck in a legacy tool, at least remember: the comma trick is a stopgap, not a solution. The goal isn't to make the numbers add up despite your format. It's to make the format work with your numbers, and that starts by refusing to settle for a silent zero.