Results 1 to 3 of 3

Round up to whole minutes

Threaded View

  1. #1
    Registered User
    Join Date
    08-12-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    1

    Round up to whole minutes

    Hi guys, maybe a simple question but a tough one for some one like me.

    I have this data set it is from my phone bill and want to round the numbers up (whole minutes). I did manage to convert the time annotation to decimals of course with your help but this one seems to be more difficult than I thought.

    I want to round 3.25 to 4.00 and 2.55 to 3.00 and 0.15 to 1.00 and so on.


    Time Time (decimal)
    3:15 3.25
    2:33 2.55
    7:03 7.05
    9:03 9.05
    5:38 5.63
    0:09 0.15
    0:05 0.08
    0:55 0.92
    0:03 0.05
    0:05 0.08
    4:29 4.48
    1:34 1.57

    Can you give me a formula to do this?.

    Thank you.
    Last edited by Rocky_bear; 08-12-2013 at 09:42 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Round Time to 30 minutes
    By Shiv in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-27-2014, 05:11 AM
  2. How do I round minutes up and down?
    By Agent007 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-08-2013, 10:50 PM
  3. How to covert and round up time to minutes
    By ramnadh in forum Excel General
    Replies: 3
    Last Post: 12-08-2010, 08:17 AM
  4. Round up a time to the next 15 minutes
    By Frederick Chow in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-05-2006, 06:41 AM
  5. How to round down to nearest 5 minutes, time calc?
    By StargateFanFromWork in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-18-2005, 05:05 AM

Tags for this Thread

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