Forum Discussion
Solved
Calculating time water level below threshold of 2.7m per event
Hi I need to calculate the total time that a water level is below the threshold of 2.7m. I need to do this for each event where this occurs. I'm trying to work out the longest period where w...
Bella_75 As with many things Excel there are more than 1 ways to skin the cat. Here is 1 that I think is pretty 'simple'. I added this equation to the column next to the depth:
=IF(D2<2.7,C2-C1+E1,0)It will simply add the latest time span to the previous if the depth is below the level and reset to 0 then above.
then in E1 I added =MAX() for that column.
Thanks Joe for your additional review and commentary. I'm most grateful for your input and help. The questions you raise are also helpful.
Thanks you to all responders.
I've resolved this query.
Thanks you to all responders.
I've resolved this query.