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

🙂

One thought on “Summing up times in Excel”

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: