Hi,
you could use a pivot table here. Drag dates to the row area and hours to
the data area. Now go to any cell in the date columns (of the pivot table)
and on the pivot table, go to Pivot table Group and Outline Group. The
group box will come up and here you can select months and years.
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"soconfused" wrote in message
...
I have a spreadsheet that looks something like this:
1 01/02/08
.2 01/06/08
.8 12/15/08
15 02/07/09
1.7 02/22/09
10 05/06/09
I want to add the first column (which is hours), but I need them added by
mm/yy.
Thanks,
--
DMM