Post Reply 
How to round an HMS number? [SOLVED]
07-21-2018, 10:02 AM
Post: #7
RE: How to round an HMS number? [SOLVED]
With the new firmware version 2.0.0.13865 (2018 07 06), the behavior of ROUND (and also TRUNC) has been changed. Now using 0, 2 and 4 as the second argument, you can round to the nearest degree, minute or second.

The function ROUND produces now the following results:

ROUND(15º16'16.99968", 0) -> 15º00'00"
ROUND(15º16'16.99968", 2) -> 15º16'00"
ROUND(15º16'16.99968", 4) -> 15º16'17"
Find all posts by this user
Quote this message in a reply
Post Reply 


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? - JMB - 01-01-2018, 06:15 PM
RE: How to round an HMS number? [SOLVED] - JMB - 07-21-2018 10:02 AM



User(s) browsing this thread: 1 Guest(s)