that.
First off Thank you for your help, no matter how much or little.
Let me tell you what my project is about in a nut shell. I take measurements from 15 water tanks every time I pull water out. The measurement is in feet and inches. The flow/fill rate in each tank is different and that rate in every tank always fluctuates so I am looking for a formula that can adjust with that fluctuation. I pull 4 or 5 feet of water at one time from each tank.
I want my spreadsheet to calculate the flow/fill rate based on the measurements from the previous pull to the pull I'm about to do. ie...I pulled the tank down to 1'6" at 12:00 pm 10/31/14. Now the tank is 5'6" at 2:00 pm 11/01/14. So the tank filled 4' in 14 hrs. I know how to do the math on paper to figure out the flow/fill rate. My problem is working with dates and times in excel. I've figured out now() and today() but I'm baffled on putting a static current time and date in a cell, something that I'm thinking should be easy.
This is what I have working so far. I have a formula that converts ie. 2'3" into 27 (inches). I have a formula that subtracts 4' or 5' from the measurement I take before I pull a load; what is remaining in the tank. This uses a cell that I put how much I will pull and the cell that contains the ' " converted into inches (the 27 in this ie). I have it layed out to where there are 2 column sections, one will have the previous date/time and measurements and the other is where I put the new info. That means every time I will put the new info in where the previous info was. I'm guessing that might be problematic with the formulas.
So here are 3 things that I would like help with. They are listed in order of importance. First, what formula will give me the number of hours between the previous date/time I took measurements and the current date/time I'm taking them. Will I have to enter the date/time in a specific format? That question leads into the second thing I need help with. How can I have excel automatically put the current date/time in a specific cell when I put my first measurement into a different cell?
And the last thing I need help with is more of a curiosity question. Is there a way for Excel to keep a log of all the previous flow/fill rate and use that info over time to get a more accurate over time.
Thank you for taking the time to read through my problem. It was a long read and I'm sorry for that. Extra Thanks to those of you who helped.
First off Thank you for your help, no matter how much or little.
Let me tell you what my project is about in a nut shell. I take measurements from 15 water tanks every time I pull water out. The measurement is in feet and inches. The flow/fill rate in each tank is different and that rate in every tank always fluctuates so I am looking for a formula that can adjust with that fluctuation. I pull 4 or 5 feet of water at one time from each tank.
I want my spreadsheet to calculate the flow/fill rate based on the measurements from the previous pull to the pull I'm about to do. ie...I pulled the tank down to 1'6" at 12:00 pm 10/31/14. Now the tank is 5'6" at 2:00 pm 11/01/14. So the tank filled 4' in 14 hrs. I know how to do the math on paper to figure out the flow/fill rate. My problem is working with dates and times in excel. I've figured out now() and today() but I'm baffled on putting a static current time and date in a cell, something that I'm thinking should be easy.
This is what I have working so far. I have a formula that converts ie. 2'3" into 27 (inches). I have a formula that subtracts 4' or 5' from the measurement I take before I pull a load; what is remaining in the tank. This uses a cell that I put how much I will pull and the cell that contains the ' " converted into inches (the 27 in this ie). I have it layed out to where there are 2 column sections, one will have the previous date/time and measurements and the other is where I put the new info. That means every time I will put the new info in where the previous info was. I'm guessing that might be problematic with the formulas.
So here are 3 things that I would like help with. They are listed in order of importance. First, what formula will give me the number of hours between the previous date/time I took measurements and the current date/time I'm taking them. Will I have to enter the date/time in a specific format? That question leads into the second thing I need help with. How can I have excel automatically put the current date/time in a specific cell when I put my first measurement into a different cell?
And the last thing I need help with is more of a curiosity question. Is there a way for Excel to keep a log of all the previous flow/fill rate and use that info over time to get a more accurate over time.
Thank you for taking the time to read through my problem. It was a long read and I'm sorry for that. Extra Thanks to those of you who helped.