Re: [libreoffice-users] Copy-Paste(special) times in Calc.

2017-03-30 Thread John Meyer
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

[libreoffice-users] Copy-Paste(special) times in Calc.

2017-03-29 Thread Steve Edmonds
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