Results 1 to 3 of 3

Rounding Time and Cut and Paste issues

Threaded View

  1. #1
    Registered User
    Join Date
    04-07-2011
    Location
    New Mexico
    MS-Off Ver
    Excel 2003
    Posts
    3

    Rounding Time and Cut and Paste issues

    I have this long list of times and I need to round each in this manner;
    0-29 seconds stay the same
    30-59 seconds round up a minute
    So if the time is 14:05:29 it should read 14:05
    And it the time is 22:13:30 it should read 22:14.
    Is there a function for this?

    Also like below, If I create a new column to the right using a function to round off these times, it's dependent on the column(original list of times) to the left isn't it?
    23:44:12 23:44
    18:22:45 18:22
    02:03:34 02:04
    13:45:46 13:46
    I suppose if I wanted to, I can't just delete the column to the left without messing with the figures in right hand column. I'm wondering if there is a way I can round these figures in a similiar manner to changing the format of the cells so that I don't have to create another column altogether. Or instead, is there a way that I could cut and past the rounded off times(just the numbers) from the right column to anywhere else in the document without carrying the function quality?
    Thank you Kindly,
    Anna
    Last edited by acfilban; 04-07-2011 at 07:55 PM.

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