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.

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.

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



