Usually when I'm pasting in time into a cell formatted for time, I'll
paste special. The worst that happens is that the time is affixed with
a single quote mark. Then I find and replace "^." with "&" (no quote
marks).
On 3/29/2017 2:32 PM, Steve Edmonds wrote:
Hi.
Playing with the
Hi.
Playing with the calculate decimal seconds I came across an interesting
thing, is it a bug, I am not sure.
Tested in LO 5.2, Linux and Win7.
If you create a list of times say 02:58.03, etc. down from A1
In the column next (B) enter =A1 and copy down. Format as [SS].00 so it
shows column