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