View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default sum hours and minutes with Excel 2000

You want a pivot table. See this website for help:
http://www.contextures.com/xlPivot07.html

Regards,
Fred.

"bill" wrote in message
...
During the year I kept a log of the hours and minutes spent daily on a
project. Now the tax man want me to post it in hours and minutes per week.
I
have Excel 2000 and I would like to add up the total number of hours spent
in
each week.

Bill