The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

This page is outdated. You will be redirected to /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

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.