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

2016-05-10 Thread Joe Conner 
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 degrees:minutes:seconds to generate traverse tables.

Steve <>



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

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

2016-05-07 Thread Steve Edmonds 
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 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  wrote:


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



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




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

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

2016-05-07 Thread Bruce Hohl 
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  wrote:

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

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

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

2016-05-07 Thread John Meyer 

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




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

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

2016-05-05 Thread Michael D. Setzer II 
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
Date sent:  Thu, 5 May 2016 12:44:59 -0400

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



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

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

2016-05-05 Thread Luuk 



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




see (for more info) point 4 of "[Tutorial] Ten concepts that every Calc 
user should know 
"

( https://forum.openoffice.org/en/forum/viewtopic.php?t=39529 )

4. Times in cells
A cell can contain a clock time, but the time is really stored as the 
corresponding fraction of a day. For example 6 AM is stored as 0.25 
because it is ¼ of the way from midnight to midnight, but it is 
displayed as 6:00:00 AM. You can use Format → Cells → Numbers → Category 
→ Time to display clock times in many formats, for example H:MM or HH:MM 
or HH:MM:SS, and any of these can have an optional AM/PM if you don't 
want to use 24-hour (military) time. A cell can contain both a date and 
a time. The value in the cell is the sum of the integer for the date and 
the fraction for the time. Format date/time cells by combining a date 
format and a clock time format. For cells which represent durations 
(difference of two clock times), the value could be more than one day, 
that is larger than 1, or even negative. The previously mentioned clock 
time formats display only the positive fraction; Calc adds or subtracts 
whole days until the time is between 00:00:00 and 23:59:59. To display a 
duration which exceeds 24 hours or is negative, you must enter the first 
part of the time format in brackets in the Format code field: [HH]:MM:SS 
or [HH]:MM or [HH] or [MM]:SS or [MM] or [SS]. There is no cell format 
which displays durations as days with hours/minutes/seconds. Be sure to 
remove the AM/PM format code from duration cells since they don't 
represent clock times, and always use one of the bracketed formats.




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

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

2016-05-05 Thread Bruce Hohl 
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 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 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
>

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

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

2016-05-05 Thread Russell 
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 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