How to round an HMS number? [SOLVED]
|
01-01-2018, 05:58 PM
Post: #3
|
|||
|
|||
RE: How to round an HMS number?
(01-01-2018 05:01 PM)salvomic Wrote: I don't know it this could help you, but I do as above in my program Effemeridi (Ephemeris) with angles: Thanks Salvo! Your function applied to my case →HMS(IP(HMS→(15º16'16.99968")*3600)/3600) returns 15º16'16" - it truncates as its name suggests. Inspired by your function I've found that →HMS(ROUND(HMS→(15º16'16.99968")*3600,0)/3600) returns 15º16'17" - the answer I was looking for. HNY! |
|||
« 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: 2 Guest(s)