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
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
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
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: