| <meta http-equiv="REFRESH" content="10;url=http://wiki.services.openoffice.org/wiki/Documentation/FAQ"> |
| <h3>This page is outdated. You will be redirected to <a href="http://wiki.services.openoffice.org/wiki/Documentation/FAQ">http://wiki.services.openoffice.org |
| /wiki/Documentation/FAQ</a> shortly.</h3> |
| <div style="margin-bottom: 10em;"></div> |
| <p><a href="../../index.html">Documentation</a> / <a |
| href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a |
| href="048.html" accesskey="p">Previous</a>-<a href="050.html" |
| accesskey="n">Next</a></p> |
| <h3>Is there a way to add times that total greater than 24hrs?</h3> |
| <p>Yes. This requires a custom number format in the cells containing |
| the times that you wish to add together. |
| </p> |
| <ol> |
| <li>With the cells selected, go to <b>Format > Cells</b>, then |
| select the <b>Numbers</b> tab.</li> |
| <li>Set the Category to <b>User-defined</b>; then, in the <b>Format |
| Code</b> input bar at the bottom, type <b>[HH]:MM</b>.</li> |
| <li>Click <b>OK</b>.</li> |
| </ol> |
| <p>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.</p> |
| <p><a href="../../index.html">Documentation</a> / <a |
| href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a |
| href="048.html" accesskey="p">Previous</a>-<a href="050.html" |
| accesskey="n">Next</a></p> |
