Hello all,
Quick question which may take some thinking cause i sure have been for a bit. I have some data that will be input that will look like the following and i want to be able to fill the spaces between these points. Trying to stay away from Macro's and VB because of the people who will be using this on a daily basis and their limited knowledge of excel. Here is some example data

Time Value
1:00:00 AM 100
1:01:00 AM 200
1:02:00 AM 300
1:03:00 AM 400

This is how the data would come to me. The problem is the values aren't going to be evenly spaced (here its obviously every 100 it has a time but that may not be the case as some times it may go every 200 or 500 unit jumps in the same set of data.)
This is how i want to make the data look

Time Value
1:00:01 AM 100
1:00:02 AM ???
1:00:03 AM ???
1:00:04 AM ???
etc . . . . . . . .. . . .
1:01:00 AM 200

The problem im running into as i said is that the value range may jump from 100 units to 500 units in the same string of data and i would like to get it so that i can reference an input table of times and values and it populate another table with the numbers at my desired increments. Also there will be a significant amount of data so just manually scrolling down and auto filling one by one is time consuming and what im ultimately trying to eliminate.

Any ideas / suggestions would be helpful and appreciated.