Summing hourly data into daily data, and converting numbered day into a date

Evening,

I've read through the forums and tried to do this myself but I'm just stuck. I don't know anything about Macros and couldn't even get one to register let alone run, and PivotTables are a mystery!

The data I have are for hourly precipitation (see attached file). They are organised by numerical day and hour and I need to do two things:

1) Convert the numerical day into a date
2) sum the hourly data to get a total for each day

Any help from more experienced users is greatly appreciated!

Thanks for reading,

Philip

Weather data.xlsx

That's...perfect. Thanks!

Where can I find this stuff out myself?!

Philip

PS As it happens, the data are for a place near the Rio Grande 50 miles south of Albuquerque...not too far from your neck of the woods?

Here are two solutions. Formula and Pivot Table

Thanks for the info, Zbor. I hadn't quite realised how big Texas was!

Philip