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 . <s...@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+unsubscr...@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+unsubscr...@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