2 Useful Excel Tips When Using HH:MM:SS Duration Format

So this weekend I was playing around in Excel trying to sort out our DVD library. I have a nice program that does most of it for me, but I wanted to do some other stuff, so Excel it was. Don't worry I'm not going to go into details about DVDs, but I did learn a couple of things that I just hadn't come across before.

I used to use Excel a lot when I was a consultant, but mostly I was doing hideously complex things in VBA, so a lot of the normal front end passed me by :).

2 Useful Excel Tips When...