At 06:54 17/07/2020 -0700, Gilles Noname wrote:
Brian Barker wrote
I'm guessing that you have text values. If so, use
=LEFT(Xn;2)*60+RIGHT(Xn;2)
That was the easiest solution:
=LEFT(F3;2)*60+RIGHT(F3;2)
Next, copy the cell (formula), select all the cells below, and paste.
Or use the "fill handle" to drag down a column.
But before, make sure the destination column is also set to Text,
like the source column.
I don't know why you think this is necessary or desirable. The result
of the formula is a number, and this is not changed by formatting the
cells as Text. If you want the values left aligned you can arrange
that separately. You can anyway format cells containing numbers
however you wish. If you really want text values, you can wrap the
original formula in the TEXT() function.
Brian Barker
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
