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