Hello i want to make a query to a dynamic field that says if the amount of seconds in the seconds column adds up to 1 hour in each cell then use the cell count as the answer. But if the amount of seconds doesnt add up to an hour then count all the cells in that column and divide it by 60 to give the correct amount of hours. Im having trouble working it out and need it done asap so any help is much appriciated.


If actually got a count query already setup so i just need to say if the seconds go up in 3600 each time then just give the answer as the amount of columns but if they dont, add them all up and divide them into hours.

Here is my working count query

FROM Rain_Data;