Time to empty spread sheet

Hi Guys,

A little help if possible,

I am trying to create a spread sheet that displays something like a water tank 0% to 100%, But you enter the time and tank level. then a second Time and tank level. which calculates the Difference in percentage and time. Then suggests how quickly it is dropping. ie 5% per hour. And finally tells me when it would be empty. If someone is able to suggest this, that would be great. I spent a heap of time on similar sheets, but un able to work out how to do %'s and time together.

Thanks Heaps, Drew

I suspect you may be looking for a visual display for this, but I think this captures the calculation part you are asking about?

Excellent, Thank you. That is Close to what I am looking for.

I like the idea of time to full. But would rather that be a Modifiable number, ie, could put [80%] and it would suggest how long it would take to get there.



Time 1 : 12:00AM
Tank Lvl: 85%

Time 2 : 14:58 PM
Tank LvL: 42%

Time to Empty
*********

Time To Full
*********

% Change Per hour per Hour
**************

Time to reach [ ] %
**************

Something like that.

Thanks Again.