+ Reply to Thread
Results 1 to 3 of 3

increment different minute in random range for each ID vba

  1. #1
    Registered User
    Join Date
    09-20-2019
    Location
    lebanon
    MS-Off Ver
    2016
    Posts
    36

    increment different minute in random range for each ID vba

    Hi I'm trying to increment the time in range size at least ( 2 min to 10 minute ) for each same ID in vba code example table:
    ID time
    1 5:5
    1 5:7
    1 5:9
    2 10:10
    2 10:15
    2 10:20

    Please Login or Register  to view this content.
    the attachment first sheet is my data the result I except is in second sheet , in sheet2 I add for the ID=1 Time+2 min and ID=2 Time+4
    I didn't know how to it any idea for that?
    Attached Files Attached Files
    Last edited by fatoom91; 01-16-2020 at 09:09 AM.

  2. #2
    Valued Forum Contributor WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    869

    Re: increment minute in random range for each ID vba

    Try like this?

    Please Login or Register  to view this content.
    WBD
    Excel 2016 on Windows 10, looking for rep!

  3. #3
    Registered User
    Join Date
    09-20-2019
    Location
    lebanon
    MS-Off Ver
    2016
    Posts
    36

    Re: increment minute in random range for each ID vba

    Quote Originally Posted by WideBoyDixon View Post
    Try like this?

    Please Login or Register  to view this content.
    WBD
    thanks alot
    I tried this code but it increment the whole column 0:04 minute (I want to make the increment random range from 2 minute to 10 minute) I mean for the first ID number increment the time 2 minute for the second ID number increment 5 minute and so on..how can I do that?
    Last edited by fatoom91; 01-16-2020 at 07:59 AM.

+ 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. [SOLVED] Increment Number in random row?
    By metaldale in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-19-2017, 02:44 PM
  2. increment one row at a time with cmd button
    By NoWhereMan2012 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2012, 06:22 AM
  3. Need to Increment Date and Set Time
    By jimmy37 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-25-2011, 02:42 PM
  4. Add a time increment when a condition is met.
    By RunHard in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-19-2009, 06:52 AM
  5. increment/random number problems
    By smackdog in forum Excel General
    Replies: 1
    Last Post: 02-06-2008, 09:17 AM
  6. An uneven time-increment
    By smurray444 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-08-2006, 01:15 AM
  7. Rounding Time Intervals to the Nearest Specified Time Increment
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-23-2005, 12:21 PM

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