Re: [libreoffice-users] Re: [Calc] Good way to turn hours+minutes into minutes?

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: users+unsubscribe@global.libreoffice.org
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