Complicated Insert Row Function

Ok, not sure if this is possible, but here is what I am trying to do and I imagine doing it (if you have a simpler solution, please feel free to suggest it)

I have a data set which consists of time codes that are various distances apart from each other. I need to fill in the gaps between them by every second.

What it looks like now (two line example):

16:03:22
16:03:29

What I want it to look like:

16:03:22
16:03:23
16:03:24
16:03:25
16:03:26
16:03:27
16:03:28
16:03:29

The data set is too large for manually inserting the rows to be practical, but I have a row that displays how many seconds difference there is between two adjacent entries (so for the example it says 7 seconds obviously), so I know how many rows need to be inserted. Is there a way to automatically insert a set of rows between each entry that references the count column so that it inserts the correct number of rows?

Thanks for your help!

Assuming
- the times in column A
- the amount of missing values in column B

Please Login or Register  to view this content.

It would help if you post a sample workbook see the forum rules).

If the rows are still empty it's easier to use autofill in Column A.

we won't need column B

if the first time value is in cel A1:

Please Login or Register  to view this content.