How to round an HMS number? [SOLVED]

Threaded Mode | Linear Mode

How to round an HMS number? [SOLVED]

01-01-2018, 05:59 PM

Post: #4

salvomic Offline

Senior Member

Posts: 1,396
Joined: Jan 2015

RE: How to round an HMS number?

(01-01-2018 05:58 PM)JMB Wrote: 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!

Happy! :-)

ciao

∫aL√0mic (IT9CLU) :: HP Prime 50g 41CX 71b 42s 39s 35s 12C 15C - DM42, DM41X - WP34s Prime Soft. Lib

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