leonpe34
04-16-2020, 12:02 PM
I have some data which is coming from a sensor, the time stamp must be every 10 minutes, however sometimes there happen data gaps which makes a problem for post data processing. Gaps can be filled in mainually but will take ages.
Example:
13-04-20 05:10:00
13-04-20 05:20:00
13-04-20 05:50:00
13-04-05 06:30:00
You see the gaps, data should be every 10 minutes. I would like to fix it by inserting rows and fill in the cell with the right time.
Maybe a macro that calculates the difference in between rows and when it is larger than 10 minutes then it insert row (s) and the time stamp that corresponds.
Example:
13-04-20 05:10:00
13-04-20 05:20:00
13-04-20 05:50:00
13-04-05 06:30:00
You see the gaps, data should be every 10 minutes. I would like to fix it by inserting rows and fill in the cell with the right time.
Maybe a macro that calculates the difference in between rows and when it is larger than 10 minutes then it insert row (s) and the time stamp that corresponds.