Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
obi-akpere
 
Posts: n/a
Default 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"
  #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"



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert seconds to minutes and seconds in excel anonymous Excel Worksheet Functions 3 December 25th 04 08:38 PM
convert seconds to minutes and seconds Brian Excel Worksheet Functions 2 December 9th 04 09:45 PM
Minutes and Seconds bob Excel Worksheet Functions 6 November 29th 04 01:21 PM
converting from digital degrees to degrees minutes seconds Patricio Boric Excel Worksheet Functions 1 November 28th 04 07:43 PM
convert 100 minute hour to a 60 minute hour Todd Excel Worksheet Functions 1 November 15th 04 06:14 PM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"