Here is what I have so far...

Beginning Tank Level | 83 |

Current Tank Level | 27 |

Difference Changed | 56 |

Timeframe in minutes | 60 |

Minutes left before tank reaches 0 | 48 |

This is the formula I used =((B2/B3)*B4)/60*100 to find out how many minutes I have left before that tank reaches 0.

I then used the following formula to find out the exact time I'll reach 0

In G8 I have

=now()

In G9 I have

=TIME(HOUR(G8),MINUTE(G8)+B5,SECOND(G8))

I must be doing something wrong because after the tank reached 0 I went back to check my sheet and the times didn't match up.

What I'd really like to do is type in the Beginning tank level, the current tank level, the interval of the two times and be told exactly when that tank will reach 0.

Another person helping me used my equations and then added his own and this is what he got...

tank level | 56 |

% Change | =B3/60 |

min left | =G2/G3 |

G4=60 | |

time | 9:11 PM |

to MT | 10:11 PM |

to 10% | 10:03 PM |

He used my difference changed to calculate when the tank will reach 0 based on a changing tank level... being able at any time to type in the tank level between the beginning tank level and 0 and then be able to instantly see when it'll reach 0.

I know this might come off as confusing and to be honest after typing this out I've achieved to confuse myself even more. Thank you in advance for any and all help.