+ Reply to Thread
Results 1 to 2 of 2

roundup seconds to minute

  1. #1
    obi-akpere
    Guest

    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. #2
    Bob Phillips
    Guest

    Re: roundup seconds to minute

    =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" <[email protected]> wrote in message
    news:[email protected]...
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1