Re: [libreoffice-users] Calc HH:MM:SS to decimal

It would be nice if there were a built in calc function to display a number as degrees of a circle, rather than using a formula to convert radians to degrees. On 05/07/2016 01:13 PM, Steve Edmonds wrote: And has given me ideas on using this feature for storing and handling angles in

Re: [libreoffice-users] Calc HH:MM:SS to decimal

And has given me ideas on using this feature for storing and handling angles in degrees:minutes:seconds to generate traverse tables. Steve On 2016-05-08 01:48, Bruce Hohl wrote: Great. And, now we know from the collective knowledge of this mailing list how dates are stored and that there are

Re: [libreoffice-users] Calc HH:MM:SS to decimal

Great. And, now we know from the collective knowledge of this mailing list how dates are stored and that there are many good ways to solve this type of problem besides what I suggested. This list is like an ad hoc LO training course. On Sat, May 7, 2016 at 9:07 AM, John Meyer

Re: [libreoffice-users] Calc HH:MM:SS to decimal

This actually worked incredibly well for my problem. On 5/5/2016 10:52 AM, Bruce Hohl wrote: Try this in cell A2 "=VALUE(A1)*24" On Thu, May 5, 2016 at 12:44 PM, Russell wrote: does anyone know if there is a formula for a cell that will transform the HH:mm:ss from

Re: [libreoffice-users] Calc HH:MM:SS to decimal

Think this is what you want. =ROUND(A1/TIME(1,0,0)*4,0)/4 On 5 May 2016 at 12:44, Russell wrote: To: users@global.libreoffice.org From: Russell <ka4...@frontier.com> Subject: [libreoffice-users] Calc HH:MM:SS to decimal Dat

Re: [libreoffice-users] Calc HH:MM:SS to decimal

On 05-05-16 18:52, Bruce Hohl wrote: Try this in cell A2 "=VALUE(A1)*24" On Thu, May 5, 2016 at 12:44 PM, Russell wrote: does anyone know if there is a formula for a cell that will transform the HH:mm:ss from another cell into a decimal equivalent? example: Cell A1

Re: [libreoffice-users] Calc HH:MM:SS to decimal

Try this in cell A2 "=VALUE(A1)*24" On Thu, May 5, 2016 at 12:44 PM, Russell wrote: > does anyone know if there is a formula for a cell that will transform the > HH:mm:ss from another cell into a decimal equivalent? > > example: > > Cell A1 has 10:45:20 > > Cell A2 would

[libreoffice-users] Calc HH:MM:SS to decimal

does anyone know if there is a formula for a cell that will transform the HH:mm:ss from another cell into a decimal equivalent? example: Cell A1 has 10:45:20 Cell A2 would change to 10.75 or Cell A1 07:26:15 Cell A2 would change to 7.44 (or round it up 7.5) Thanks Russell -- To