Re: [libreoffice-users] record durations, not time of day

On 1-8-2019 05:05, Alan B wrote:
> If entered just as you've typed, it seems all the formats presume hrs,
> minutes, and seconds. Applying the time formats don't cause the display you
> wish because the "3" is presumed hours and the "5", minutes.
>
> Enter instead 0:3:5
>
> Then this custom format should do:
> MM:SS displays 03:05
>
> Available ready made formats display as follows...
> [HH]:MM:SS.00 displays 00:03:05.00
> MM:SS.00 displays 03:05.00
> [HH]:MM:SS displays 00:03:05
> HH:MM:SS displays 00:03:05
> HH:MM displays 00:03

When using square brackets in hours ('[HH]')  the time does not stop at 
23:59

25:00 with format [HH]:MM will show 25:00

when using format HH:MM, it will show 01:00


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