roundup seconds to minute

[obi-akpere]

Please help, I am doing voip telephony and want to know how I can roundup
seconds to minute; 0:01, 3:33, etc to a single digit.
Thanks in advance.

 

[Bob Phillips]

=ROUNDUP(A1*1440,0)/1440

See http://www.xldynamic.com/source/xld.Rounding.html#time for an
explanation

--

HTH

RP
(remove nothere from the email address if mailing direct)