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](http://geekworker.com/files/2013/02/timesums03.png)
25h not 1h
🙂
One thought on “Summing up times in Excel”