Re: [libreoffice-users] Calculate decimal seconds

Hi Steve, For my application using the [SS].00 option did the trick. As I required to determine number of seconds required to move 500m. I also need to sum up the resultant column. Thanks for all the help both on-line and off-line. Vytas On 3/29/2017 3:20 PM, Steve Edmonds wrote: Hi. 2

Re: [libreoffice-users] Calculate decimal seconds

Hi. 2 interesting options, which one you choose depends upon what you want to do with the number you get. You need to bear in mind that option 2 is just showing you DAYS in a different format. If the time is how long to run 100 (m/ft) and you want to calculate a speed for instance you would

Re: [libreoffice-users] Calculate decimal seconds

2017-03-29 15:38 GMT+02:00 vytas : > I have a spreadsheet containing timing results which are displayed using > the a Format code of MM:SS.00 (02:58.03). > > What I require is the number of seconds the cell represents as a decimal > number of seconds (178.03) for the above value.

Re: [libreoffice-users] Calculate decimal seconds

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Helo Vytas, > > I have a spreadsheet containing timing results which are displayed > using the a Format code of MM:SS.00 (02:58.03). > > What I require is the number of seconds the cell represents as a > decimal number of seconds (178.03) for the