Summing up times in Excel

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 times – Excel will “wrap around” at 24h:

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

Works like a charm:

Times wrap around

25h not 1h