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

I want to enter numbers in Calc like 3:05 that stands for 3 minutes and 5 seconds (duration), not for some time of day. How do I do this? Eric Beversluis Short fiction at www.ericbeversluis.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreof

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

At 18:44 31/07/2019 -0400, Eric Beversluis wrote: I want to enter numbers in Calc like 3:05 that stands for 3 minutes and 5 seconds (duration), not for some time of day. How do I do this? If you format your cells as Text, there is nothing to stop you entering 3:05 just as you say, and then to

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

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 re