How to round an HMS number? [SOLVED]
|
01-01-2018, 04:53 PM
(This post was last modified: 07-21-2018 09:56 AM by JMB.)
Post: #1
|
|||
|
|||
How to round an HMS number? [SOLVED]
I'd like to know if it is posible to round the seconds in a number written in HMS format.
Here is an example. I'd like to round the number 15º16'16.99968" to 15º16'17". The function ROUND produces the following results: ROUND(15º16'16.99968", 0) -> 15º00'00" ROUND(15º16'16.99968", 1) -> 15º18'00" ROUND(15º16'16.99968", 2) -> 15º16'12" ROUND(15º16'16.99968", 3) -> 15º16'15.6" ROUND(15º16'16.99968", 4) -> 15º16'17.04" It seams that ROUND first converts 15º16'16.99968" to its decimal equivalent 15.2713888, then rounds this value to the specified number of decimal places (for example for 3 decimal places -> 15.271) and then converts this value back to the HMS format (15º16'15.6") So, does anyone know how to get 15º16'17"? |
|||
« Next Oldest | Next Newest »
|
Messages In This Thread |
How to round an HMS number? [SOLVED] - JMB - 01-01-2018 04:53 PM
RE: How to round an HMS number? - salvomic - 01-01-2018, 05:01 PM
RE: How to round an HMS number? - JMB - 01-01-2018, 05:58 PM
RE: How to round an HMS number? - salvomic - 01-01-2018, 05:59 PM
RE: How to round an HMS number? - Tim Wessman - 01-01-2018, 06:04 PM
RE: How to round an HMS number? - JMB - 01-01-2018, 06:15 PM
RE: How to round an HMS number? [SOLVED] - JMB - 07-21-2018, 10:02 AM
RE: How to round an HMS number? [SOLVED] - Tim Wessman - 07-21-2018, 12:44 PM
|
User(s) browsing this thread: 1 Guest(s)