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

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Formatting
Jump to: navigation, search


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


Yes. Select a format code with the hour symbols in square brackets, like [HH]:MM.

  1. Select the cell you want to apply the format to
  2. Select Format - Cells from the main menu
  3. Select the Numbers tab
  4. Set the Category to Time
  5. Select one of the formats with hours > 24, for example [HH]:MM:SS
    you can also select the Format Code line and enter the format yourself
  6. 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.


Personal tools