If you're using Chrome, the right column of this blog isn't displaying correctly. Switch to Firefox. If you're using the iPad, you're a tool. If you're using IE, go kill yourself.
(This person is kinda upset that I dissed their favorite browser. I actually use Chrome and I like it, but for some reason the layout here is different than on Firefox. And of course, the iPad and IE just plain suck. You tool.)

Friday, June 11, 2010

Summing hours in Excel that exceed 24 hours...

To automatically format times that when added together exceed 24 hours, 60 minutes, or 60 seconds, you can use the following custom number formats and the SUM function in Excel:

* Hours = [h]:mm:ss
* Minutes = [m]:ss
* Seconds = [ss]

If you have OpenOffice, you don't have to worry about this because it automatically does it for you.

Categories:

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)