Re: [libreoffice-users] Calculate decimal seconds

[vytas]

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 :

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+unsubscr...@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

Re: [libreoffice-users] Calculate decimal seconds

[Steve Edmonds]

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 :


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+unsubscr...@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

Re: [libreoffice-users] Calculate decimal seconds

[Cley Faye]

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.
>

​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

-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] Calculate decimal seconds

[Robert Großkopf]

-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 above value.

Changing the format to
[SS].00
wold help.

Regards

Robert
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJY289AAAoJELDKYwaoS9AIew4P/jYPKREEQYuubE6qoTOUoUkX
qCMw/jS2LC1wxarnyxGwF7XpfIxw+VM71t25BYPM+jVdMD3oM4xnVEOYJq6jJiqG
PZdzBLP3mbmuFs6ManeE7vDJpMX3qIABUO25ZCEwFQvfZR0L7u5JNhuoRw15SfBN
9Q426B6OiNoaq7DVKqBv4C1f5x3DPBkW9sAxFQGMRhBtgW5RKTxp9z/efkojQXcv
thQObq+Ym/0lzPGGbkpr9aQ6wepagcAtQIw3SH4JKmmhEsK0hemdWos1khmq0UjI
g7pjfhQ051GfdgWf70SLDnB/TtADbr8bWHTf6UX7yXEgdDWMUUnTHsCcA1mphPUZ
jyKGNfzd5X+tlwQxVNxfYmMYElFXPAO/K19qfzmINLOriNWcZ7oS6+PKq2gbLqJ3
yExRPrmbPfsEn590vXTpklORD+AJoyipMI92Y8gG/aBuKjsWYiP232jGjNkxmlSq
HqIsFVcnvWANPp5UGYmD6jUUcpYq9QfESRy9lY4lxioozumb09lfFrrV9Z4Z0LKY
zXj+zdeVn8N485XbpE2TeF194HIeBsW3/aO6/Nd8eDbZI7LdXZ3bKGb1n0d/gral
GJMqQ9bQYL+dPPKmyqtxAYtpfNwfRtMQIg24kwSsu9v2Iv0I60Vperb3L/s4InVb
D2ruLsp7bTnRU77nPJrZ
=bB+l
-END PGP SIGNATURE-

-- 
To unsubscribe e-mail to: users+unsubscr...@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