ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   roundup seconds to minute (https://www.excelbanter.com/excel-worksheet-functions/8821-roundup-seconds-minute.html)

obi-akpere

roundup seconds to minute
 
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"

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)


"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"





All times are GMT +1. The time now is 12:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com