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: [email protected]
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
