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 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 divide 100 by the seconds.
> Option 1 will give you the m(ft)/second velocity.
> Option 2 will give you the m(ft)/day velocity.
>
> Quite different answers.
> Steve
>
> On 30/03/17 05:06, Cley Faye wrote:
> > 2017-03-29 15:38 GMT+02:00 vytas <vytas@magma.ca>:
> >
> > > 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.
> Option 1
>
> > > ​The actual, numerical value stored in such a cell is a number of 
> > > day. To
> > > find this out, you can remove formating.
> > >
> > > Suppose you have 02:58.03 in A1, you put "=A1" in A2, then Ctrl+M to 
> > > remove
> > > formatting, it will show you something like 0.002060532
> > > To convert from "number of day" to "number of seconds", multiply with
> > > 60*60*24. For example, putting "=A1*60*60*24" in A3 will display 178.03
> Option 2
> > > Changing the format to
> > > [SS].00
> > > wold help.
> > >
> > > Regards
> > >
> > > Robert


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted