Hi, I currently have to deal with analysing street noise.
I have a table where sound level is recorded over time, i.e. I get two values per row, a timestamp and a decimal value between 35 an 100(ish).
Now I want to identify the peaks (have their timestamp), if their duration is longer than 2 seconds and their value above 70.

File example (not matching with the picture) looks like
13-07-2019,00:16:59, 38.50
13-07-2019,00:17:00, 78.30
13-07-2019,00:17:01, 78.30
13-07-2019,00:17:02, 38.90
13-07-2019,00:17:03, 55.30
13-07-2019,00:17:04, 39.90

Maybe the picture makes it clearer
sound.jpg

Currently I have slightly over 200.000 lines only, but increasing by 86k/day, so at the end of my 10 days I'll end up with 864k lines

Is there a chance to do this check by EXCEL or shall I go SQL ?
Having a first solution with EXCEL would be a good start

Txs