Hi everyone,

I am trying to find the time from the given set of values.

b1 - starting distance c1 - end distance d1 - speed e1 - time
B C D E
1 0.00 1.25 24 00:03:08
2 1.25 1.75 36 00:00:50
3 1.75 3.10 18 00:04:30
4 3.10 3.90 28 00:01:43
5 3.90 5.00 32 00:02:04

The column E contains this formula
(C1-B1)/(D1*24) and it displays the time as 00:03:08

Now I have set of distances and I need to find the time.

Eg:

H1 = 1.20 in I1 I get 0:03:00
H2 = 1.25 but in I2 I get 00:00:05

This answer what I get in I2 is wrong.
In I2 the answer should be 00:00:08 Seconds.
Because both the values lies inbetween the same values of C1.
I tried using this formula
(H2-B2)/((D2:D6)*24) but it gave correct value for the 1st value.
Rest all I am getting wrong answers.

The following are the values in H1:H5

H I
1.20 00:03:00
1.24 00:00:06
3.23 00:05:38
4.44 00:02:27
4.96 00:00:58

Am only getting I1 as correct answer. The values in Column are correct because I did the calculation work manually.

Could somebody help me in solving this problem.

Regards,
Naga