![]() |
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" |
=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