So just sort by the date and do data|subtotals. You'll see each day's total.

huffmjb wrote:

Cells do not contain any time
Below is a sample of the sheet, I am exporting this data into excel from SAP
so the layout is what I get.
I am lookin for a way to get a sum for column B,C & D for each day (ie:
2006/01/01)
There are many entries for each day.


A B C D

2006/01/01 8 8 9
2006/01/01 8 9 9
2006/01/01 6 6 4
2006/01/02 5.5 5 5
2006/01/02 8 5 6
2006/01/02 9 5 6
2006/01/02 10 8 7
2006/01/03 7 6 7

"Dave Peterson" wrote:

If you sort by column A, you can use Data|subtotals to add up those hours.

If the hours are really cells containing time (5:00 or 7:30), then format the
subtotals as [h]:mm.

It'll avoid a problem if the subtotals exceed 24 hours.

Or you may want to look into Data|pivottable.

huffmjb wrote:

Column A has dates eg: 2006/01/01, 2006/01/02 with many entries for each date.
Column B, C, D has data of hours used on these dates.
I am looking for a way to get the sum of each column specific to a date
(daily totals)

--

Dave Peterson


--

Dave Peterson