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.
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.
Holy moly. That's great. I needed three columns to process the data using my alternative method. Thankyou so so much for your time and help.