Hi all
I have a sheet with the data collected from a weather station on it. The rainfall is collected/recorded every 10mins, and some days every 30mins.
What I want to do is total all the rainfalls for that day and put the total in another column.
So column A Date and Time
Column B Rainfall recorded
Column C daily total

Is there a function to do this?
Ideally one function dragged down the column would be the answer.
I'm not too hot on Date type functions.
Thank you
Fermerboy