converting hourly rainfall data into a daily rainfall sum

hi

Here is the file I'm working on.
how can i convert hourly rainfall to daily rainfall in each station acc to "station_i" & "time" & "hourly rainfall" columns?


Thanks a lot for any assistance which you might be able to offer.

behnam

this is a duplicate thread.. lets continue in

https://www.excelforum.com/excel-for...nfall-sum.html

that already has answer(s)