The tank was 40 cm deep at minute 10 and 52 cm at minute 30. You missed minute 15. Estimate it from the line between the readings and mark it as an estimate.

Enter the two measurements and target time

Put 10 and 40 in A2:B2, then 30 and 52 in A3:B3. Enter 15 in D2 and calculate in E2:

=B2+(D2-A2)/(A3-A2)*(B3-B2)

Minute 15 is one quarter of the way through the interval. One quarter of the 12 cm rise is 3 cm, giving 43 cm.

Minute 15 is a quarter of the way through the measured interval and the estimate is 43 cm.

Illustrated interpolation. The sample assumes a steady change between readings.

Test the measured endpoints before relying on the estimate

Try 10 and 30 in D2. The formula should give 40 and 52. Check for identical input times before dividing. For a target outside the two times, find a measured pair that surrounds it. A straight line can be a poor estimate even within the interval if the level changed in steps.

Testing minute 10 and minute 30 reproduces the measured levels 40 cm and 52 cm.

Illustrated endpoint check. Label the interior value as an estimate.