How to automatically fill range by interpolating between lower and upper bounds

I apologize I do not have any code or examples too show for this. I am not sure how to even approach or identify the function or result I would like to achieve.

What I have is spreadsheet with recorded data times and events. I will need to chart this to look for correlation against other data, so I will need all points to have complete data sets. When the data was recorded it has some empty fields. So I am looking to a way to generate a range to complete the empty fields.

1240    missing bottle
110     missing bottle
140     missing bottle
1145    bottles fell out
        hungup
        bottles fell out
        bottles fell out
        bottles fell out
        bottles fell out
        bottles fell out
1520    bottles fell out
1550    bottles fell out
1615    up
1645    bottles fell out
1715    up

So I would like to just balance the values in between 1145 and 1520, in a automated way. Since there is 6 spaced between them with a difference of 375/6 = 62.5. Is there a way to to do this automatically?

Solution 1:

Highlight the first and last values along with the blank cells, this is your range.

Now you can go to the ribbon at Home - Editing - Fill and select series... It should predict your step value for you:

results:

Or, you can do the same and specify your own step value.