mathias1979
Technical User
I was directed over here from the VB forum. I have a dataset which has data reported every hour. Problem is, there are sometimes gaps in the data (several hours missing) or extra data (data reported in between hours). I've never used VB before, but I need to figure out how to fill in the gaps with blank cells and delete extra cells (as the datafile is too long to do this manually). So what I need to do is:
-Find time increment between cells A1 & A2
-If time increment < 10 min, delete Row 2, retest A1 & new A2
-If time increment > 10 min, insert row between Row1 & Row2 and move on to test A2 & A3
-end process at last cell
Can anyone help me with the syntax needed to accomplish this? Thanks!
Matt
-Find time increment between cells A1 & A2
-If time increment < 10 min, delete Row 2, retest A1 & new A2
-If time increment > 10 min, insert row between Row1 & Row2 and move on to test A2 & A3
-end process at last cell
Can anyone help me with the syntax needed to accomplish this? Thanks!
Matt
