problem in convert from 15 minutes to 10 minutes

dear
i have records for wind speed and its every 15 minutes as you see in pictures below ...what i want to do is to convert it from every 15 minutes to every 10 minutes for example for one hour from

Table 1
14:00 5.55
14:15 6.75
14:30 6.36
14:45 6.44
15:00 6.19


to
Table 2
14:00 (the same value of previous table)
14:10 (the average of 14:00 and 14:15)
14:30 (the same value of previous table)
14:40 (the average of 14:30 and 14:45)
14:50 (the average of 14:45 and 14:15:00)
15:00 (the same value of previous table)

how can i do this task ???i tray some solution but the hard problem face me how to keep the same value from previous table in new table

thank u very much
but there is minor problem
the (14:30) value in table 1 not equal to (14:30) in table 2 -the new table-

Table 1
14:00 5.55
14:15 6.75
14:30 6.36
14:45 6.44
15:00 6.19

Table 2

14:00 5.55
14:10 6.15
14:20 6.56
14:30 6.40
14:40 6.40
14:50 6.32
15:00 6.19

Originally Posted by oeldere

Make sure the format is all the same for the whole sheet.

See the attached file.

thanks very mach
i tray to make my own file but i faced this problem
problem 1.jpg

how can i avoid it

attached my excel file with formula

=IFERROR($E1,$A$1:$B$17,2,0),(INDEX($A$1:$B$17,MATCH($E1,$A1:$A$17,1),2)+INDEX($A$17:$B$17,MATCH($E1,$A$1:$A$1:$A$17,1)+1,2))/2)

my excel file

thank u very much
please can u help me how to avoid error i make it as in my excel file
can u explain me the formula you make (document or link can explain the formula)

=IFERROR($E1,$A$1:$B$17,2,0),(INDEX($A$1:$B$17,MATCH($E1,$A1:$A$17,1),2)+INDEX($A$17:$B$17,MATCH($E1,$A$1:$A$1:$A$17,1)+1,2))/2)

this my formula when i tray to run it i have this error Message ...can you help me how to avoid it

http://www.iraqup.com/up/20130601/27...X_98073434.jpg

another question please

=IFERROR($E1,$A$1:$B$17,2,0),(INDEX($A$1:$B$17,MATCH($E1,$A1:$A$17,1),2)+INDEX($A$17:$B$17,MATCH($E1,$A$1:$A$1:$A$17,1)+1,2))/2)

can u explain me the (red)
i so appreciated for your help

dear can you check attached file and tell whats problem with it

the problem that the value of 10:30 AM in first table not equal to the value of 10:30 AM in generated table


10:00:00 AM 2.23 10:00:00 AM 2.23
10:15:00 AM 1.67 10:10:00 AM 1.95
10:30:00 AM 1.75 10:20:00 AM 1.71
10:45:00 AM 1.52 10:30:00 AM 1.71
11:00:00 AM 1.30 10:40:00 AM 1.635
11:15:00 AM 0.76 10:50:00 AM 1.41
11:30:00 AM 0.78 11:00:00 AM 1.41
11:45:00 AM 0.67 11:10:00 AM 1.03
12:00:00 PM 1.12 11:20:00 AM 0.77
12:15:00 PM 0.86 11:30:00 AM 0.77
12:30:00 PM 1.17 11:40:00 AM 0.725
12:45:00 PM 0.61 11:50:00 AM 0.895
1:00:00 PM 0.42 12:00:00 PM 0.895
1:15:00 PM 0.63 12:10:00 PM 0.99
1:30:00 PM 0.06 12:20:00 PM 1.015
1:45:00 PM 0.64 12:30:00 PM 1.015
2:00:00 PM 1.30 12:40:00 PM 0.89
2:15:00 PM 1.05 12:50:00 PM 0.515
2:30:00 PM 1.04 1:00:00 PM 0.515

attached file

OK thanks plz need your help

plz check the file you already made it tom me it work and very effictive but when i copy the formula
=IFERROR(VLOOKUP($E1,$A$1:$B$17,2,0),(INDEX($A$1:$B$17,MATCH($E1,$A$1:$A$17,1),2)+INDEX($A$1:$B$17,MATCH($E1,$A$1:$A$17,1)+1,2))/2)

to another file it is not work (check the first attachment) also so i need to explanation why this error

my problem is i need formula or help in this task :
i have records for wind speed and its every 15 minutes as you see in pictures below ...what i want to do is to convert it from every 15 minutes to every 10 minutes for example for one hour from

Table 1
14:00 5.55
14:15 6.75
14:30 6.36
14:45 6.44
15:00 6.19


to
Table 2
14:00 (the same value of previous table)
14:10 (the average of 14:00 and 14:15) the new value should = 6.15
14:20 (the average of 14:14 and 14:30)
14:30 (the same value of previous table)
14:40 (the average of 14:30 and 14:45) the new value should =6.55
14:50 (the average of 14:45 and 14:15:00)
15:00 (the same value of previous table)

your answer and help is useful but the problem with it it work only on file you upload it when i copy your formula in another excel sheet it is not work the file attached named (AA) in previous post it is your work but when i tray to copy your formula to another file as in file (book1) attached in post 2
it is not work

so please to help in check the error of formula in the first attached file

Originally Posted by oeldere

See my request in #7.

OK see attached file

Originally Posted by oeldere

In which column I will find the result?

in column M

up for more