Re: [libreoffice-users] Adding Time in hours
Excellent! You solved the problem. Thank you, Peter On 5/25/23 06:45, Brian Barker wrote: At 06:29 25/05/2023 -0400, Dotty Peter wrote: 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 That's because you have the sum formatted as HH:MM or something similar. That's a clock time, not a time interval. And three and a quarter hours after a quarter to midnight is indeed three a.m. I need the sum total hours no matter if it's beyond 24. Try [HH]:MM (or similar) instead. I trust this helps. Brian Barker -- 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
Re: [libreoffice-users] Adding Time in hours
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 . 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
Re: [libreoffice-users] Adding Time in hours
At 06:29 25/05/2023 -0400, Dotty Peter wrote: 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 That's because you have the sum formatted as HH:MM or something similar. That's a clock time, not a time interval. And three and a quarter hours after a quarter to midnight is indeed three a.m. I need the sum total hours no matter if it's beyond 24. Try [HH]:MM (or similar) instead. I trust this helps. Brian Barker -- 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
[libreoffice-users] Adding Time in hours
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
