Interpolate values for different times

[kapilrakh]

Hi,

I have collected several temperature values for a 24 hour period. Time is given in column A and values is in B. I want to interpolate and get the values for the times given in column D.Linear interpolation would suffice Please reply.
I am attaching workbook here.

Thanks
K

[Marcol]

Not sure if I am reading this correctly or if there is data missing from your sample sheet.

Try this and see if it is close

Run the macro "InterpolateTimesReturnTemp"

Hope this helps

P.S.

I've added some explanation data to the worksheet to hopefully explain what I mean.

Attachment updated 16:14(GMT)

[kapilrakh]

It looks like you interpolated only 22 values instead of 24. I ran the Sub you wrote in the code. I have added little more data on the boundaries.Please have a look at it.
Thanks a lot.

[daddylonglegs]

For a formula approach try this formula in E1 copied down

=LOOKUP(D1,A$1:A$1142,B$1:B$1142+(B$2:B$1143-B$1:B$1142)*(D1-A$1:A$1142)/(A$2:A$1143-A$1:A$1142))

[kapilrakh]

Thank you sir. I will have to start using Lookup . The function I usually ignore.

[Marcol]

I have amended the code to use the first and last data in your new data list..

To allow a check on the table I have added to the code.
It now transfers the date and temperature as each hour changes.

I have added DonkeyOtes' formula for comparism,
Note it will only work if you have already extracted the Date/Time Table.

The code does this for you in one operation

Hope you find this is what you require.

Cheers

Updated file attached.

[kapilrakh]

Marcol,
Thanks for that . I got the answer using one more approach. I converted all the times to epoch times by using datediff function.
The interpolation is linear. Hence uses a simple formula of

Y = (X - x1) * (y2 - y1) / (x2 - x1) + y1

Look for sub Linterp() .

Converting time to epoch time was useful.