A pivot table can get you there in a matter of seconds

Assuming the table posted is in cols A & B,
data from row2 down, with real dates in col A

Steps (in xl2003)
Select any cell within the data,
click Data PivotTable...
Click NextNext
In step 3 of the wiz, click Layout
Drag n drop "Date" within ROW area
Drag n drop "Hours" within DATA area
Click OK Finish. That's it!

Hop over to the pivot in the new sheet to the left,
where it'll show all the unique dates in the left col,
with corresponding total hours next to it.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,200 Files:354 Subscribers:53
xdemechanik
---
"Andy" wrote:
Is there an easier way to make the same date only show in one column and add
the hours of the same dates together in that column than to do it all one by
one???

Date Hours
2008/03/26 1.50
2008/03/26 7.50
2008/03/26 1.50
2008/03/27 1.00
2008/03/27 10.50
2008/03/28 8.00
2008/03/28 1.00
2008/03/28 5.00