View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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


"obi-akpere" wrote in message
...
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.

--
"I am illiterate and ready to learn"