View source for Documentation/FAQ/Calc/Formatting/Is there a way to add times that total greater than 24 hrs?

From Apache OpenOffice Wiki

← Documentation/FAQ/Calc/Formatting/Is there a way to add times that total greater than 24 hrs?

You do not have permission to edit this page, for the following reasons:

• The action you have requested is limited to users in the group: Users.
• You must confirm your email address before editing pages. Please set and validate your email address through your user preferences.

---

You can view and copy the source of this page:

{{DISPLAYTITLE: Is there a way to add times that total greater than 24 hrs?}} <section begin=question/> '''Is there a way to add times that total greater than 24 hrs?''' <section end=question/> <section begin=answer/> Yes. Select a format code with the hour symbols in square brackets, like '''[HH]:MM'''. # Select the cell you want to apply the format to # Select {{menu|Format|Cells}} from the main menu # Select the '''Numbers''' tab # Set the Category to '''Time''' # Select one of the formats with hours > 24, for example '''[HH]:MM:SS'''<br>you can also select the '''Format Code''' line and enter the format yourself # Click {{button|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. <section end=answer/> [[Category:Documentation/FAQ/Calc/Formatting]]

Return to Documentation/FAQ/Calc/Formatting/Is there a way to add times that total greater than 24 hrs?.