+ Reply to Thread
Results 1 to 2 of 2

round time

  1. #1
    Forum Contributor
    Join Date
    08-06-2014
    Location
    iran
    MS-Off Ver
    2016
    Posts
    110

    round time

    hi
    i have time series data and i received it with just 1 or 2 minute delay or forward time so how can i change it to exact 10 minute
    for example:
    6/1/2016 20:40 -3.13
    6/1/2016 21:00 -3.04
    6/1/2016 21:10 -3
    6/1/2016 21:20 -2.9
    6/1/2016 21:30 -2.9
    6/1/2016 21:42 -2.84
    6/1/2016 21:52 -2.78
    6/1/2016 22:02 -2.72
    6/1/2016 22:10 -2.72
    6/1/2016 22:22 -2.61
    6/1/2016 22:32 -2.55
    6/1/2016 22:42 -2.51
    6/1/2016 22:49 -2.47

    in line 6 i have to change data 6/1/2016 21:42 -2.84 in to 6/1/2016 21:40 -2.841 and
    6/1/2016 21:52 -2.78 in to 6/1/2016 21:50 -2.78 and so on
    ......22:00
    ......22:20
    ......22:30
    ......22:40
    and 6/1/2016 22:49 -2.47 in to 6/1/2016 22:50 -2.47
    note: some how we lost data at the exact time for example in line 1 & 2 ( 20:40 21:00) we missed 20:50
    thanks so much

  2. #2
    Registered User
    Join Date
    02-14-2017
    Location
    Hosle, Norway
    MS-Off Ver
    2013, 365, 2016
    Posts
    35

    Re: round time

    Hi,

    Excel has a neat formula to round time to nearest x minutes. Try it and see if it helps you find a solution.

    If your time in A2 is 21:42, the formula below will return 21:00

    =Mround(A2,"0:10")

    Best regards
    Tbez

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to round up time to the nearest given end time.
    By Shellybelly in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-15-2015, 05:43 PM
  2. Round the time
    By SuddenImpact in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-08-2015, 02:40 AM
  3. [SOLVED] Round the time
    By kumawat_s in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-04-2013, 08:09 AM
  4. [SOLVED] round up time unless already at the desired time value
    By mattgoudey in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-13-2013, 10:20 AM
  5. [SOLVED] Round Time?
    By mycon73 in forum Excel General
    Replies: 3
    Last Post: 09-22-2012, 11:06 AM
  6. round the time
    By legepe in forum Excel General
    Replies: 2
    Last Post: 03-04-2010, 09:27 AM
  7. [SOLVED] Round down for time
    By Shadowman13 in forum Excel General
    Replies: 3
    Last Post: 05-20-2005, 07:06 PM

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