It’s the small things, sometimes – something I never needed to do in my old jobs is calculating with time. One very simple task is to just add up a set of durations – Excel will “wrap around” at 24h:

So we only worked 1h? never!

There’s a simple solutions for this problem. Just surround your hours with square brackets when formatting the cell, like so:

Square Brackets for the win

Works like a charm:

25h not 1h