Formula for counting rain days of the year, month, and or week

Hi Guys,

I need to count the number of days it rained of a given time (year,month, and week).

I have rainfall data of 2 years with 30 mins data interval and I need to summarize the rain days of the year, the month of a given year, and the week of the given year (week 5 for example). I can't think of a formula to solve this since my data is in 30 mins interval not daily.

please see this link below to see my data sheet;
https://www.dropbox.com/s/p58ao5lh9e...days.xlsx?dl=0

or see attached.

Any help would be greatly appreciated.

Thanks,
DEAN