You can convert daily data to weekly data in Excel by creating a pivot table, and grouping the rows in the pivot table in groups of seven days, or one week.

Excel considers dates and times as numbers in cells, making calculation difficult. Excel processes 6 AM as "0.25," because it is one quarter of the way through the day. If you need to add a number ...