Wednesday, February 20, 2013

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:

[caption id="attachment_144" align="aligncenter" width="456"]Times wrap around25h not 1h[/caption]