On Mon, 21 Oct 2013 22:48:57 +0100, dot10 wrote:


Hi,

This is my first time working with precipitation data. I received a
dataset with 15 minute data and a daily dataset. I need them both to be
24 hour data.


Use a Pivot Table

Insert / Pivot Table

Then drag the dates to the Rows area; pptn data to the Values area.
Ensure that you are seeing "Sum of ..."

Finally, right-click in the rows and choose to Group by Days