Hey everyone,
I need a formula to calculate meter flow.
Each day I get a flow reading. I must subtract the following days reading to get my daily flow.
The meter may have zeros in the beginning and must have three zeros at the end.
My formula must keep any zeros at the front and add three zeros in the end and the calculate the actual gallons per day.
Here is my example and how I formatted the sreadsheet.
Thanks for the help.
Bookmarks