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

On 7/17/20 8:56 AM, James Knott wrote:
> On 7/17/20 8:37 AM, Gilles wrote:
> > I have a spreadsheet where time is formatted as HHhMM.
> >
> > In the next column, I'd like to show this in minutes. What would be a 
> > good
> > way to achieve this?
>
> Many years ago, when copying records to  cassettes (remember them?), I 
> used the decimal degree to degree, minute, second conversion function 
> on my calculator to do that.  Perhaps that would work for you.  In 
> Calc of course, not with a calculator. ;-)

I don't see that particular function in Calc, but here's a way to 
accomplish the same thing:
https://www.calculatorsoup.com/calculators/conversions/convert-decimal-degrees-to-degrees-minutes-seconds.php

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