I'm currently trying to make a Pi calculation to predict the end of day total water discharge at our plant using instantaneous flow rate, current total flow rate, and the amount of time left in the day. Mathematically, I know what I am trying to do, and have gotten the formula to work in Excel, but I'm unsure of how to use "now" or "midnight" in a Pi formula.
What I'm mathematically trying to do is:
=(Instantaneous Flow Rate)*(Time Left Today)+(Current Total Discharge Volume)
What's the best way to get the "Time Left Today" value? Should I set up a different calculation that does that? Are you able to manipulate time in a Pi Calculation? Any kind of help would be greatly appreciated.