CTRL+1 opens the Cell Format dialog window. There, in "numbers" tab, you
have to choose "Time" on the left panel and the 4th format on the centre
panel ("876613:37:46" corresponding to [HH]:MM:SS format code).
That's it, it's not related to LibreOffice Calc but to SpreadSheets' usage
in general :)
---
Gabriele Ponzo
Il giorno gio 25 mag 2023 alle ore 12:31 . <SE@shch262.com> ha scritto:
In adding time of hours and minutes, when the total is greater than 24 hours, the total reduces to minutes. For example; 23hours 45 minutes PLUS 3 hours 15 minutes Total- 3 hours I need the sum total hours no matter if it's beyond 24. Thanks, Peter -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
-- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy