This page is outdated. You will be redirected to http://wiki.services.openoffice.org /wiki/Documentation/FAQ shortly.

Documentation / User FAQ / Calc / Previous-Next

Is there a way to add times that total greater than 24hrs?

Yes. This requires a custom number format in the cells containing the times that you wish to add together.

1. With the cells selected, go to Format > Cells, then select the Numbers tab.
2. Set the Category to User-defined; then, in the Format Code input bar at the bottom, type [HH]:MM.
3. Click OK.

Now when you add the times from cells with this format together, you will get the true sum of hours and minutes. Otherwise, the sum will reset to zero each time 24 hours is reached. This new format will be located under the Time Category, at the bottom of the list of Formats, until you add more custom formats that fall into this category.

Documentation / User FAQ / Calc / Previous-Next