1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Inserting rows for Missing Date and Time data (Excel 2007)

Discussion in 'Business Applications' started by TiagoDias1, Dec 15, 2017.

Thread Status:
Not open for further replies.
  1. TiagoDias1

    TiagoDias1 Thread Starter

    Joined:
    Dec 15, 2017
    Messages:
    2
    Hi everybody,

    I upload an excel file to help understand my problem.
    So I have date and time and in column 2 I have my parameter value.

    Note 1) not all the data is at 04:30:00, and this is a huge problem in the macro I found online.

    1-1-16 0:00 1
    4-1-16 4:30 1
    8-1-16 4:30 1
    11-1-16 4:30 1
    15-1-16 4:30 1

    What I want to create is the missing data time, associated with a column 2 blank and not 0 if possible

    So the final result should be like
    1-1-16 0:00 1
    1-1-16 0:01 "blank" (not zero if possible)
    1-1-16 0:02 "blank"
    ...
    4-1-16 4:30 1
    4-1-16 4:31 "blank"

    Thanks for your time
     

    Attached Files:

    • 1.xlsx
      File size:
      28.7 KB
      Views:
      1
  2. TiagoDias1

    TiagoDias1 Thread Starter

    Joined:
    Dec 15, 2017
    Messages:
    2
    I got to work with a code i found online and adjust to my case.

    Now my 2nd question is if it possible to do that more times, because the macro I use only makes for column A and B, and i want to repeat for C and D. I do not know if it possible to do that maybe with a while cycle for something i dont know
     

    Attached Files:

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1201183

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice