View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Atishoo Atishoo is offline
external usenet poster
 
Posts: 267
Default sum hours and minutes with Excel 2000

just set your cell format to [h]:mm:ss
its at the bottom of the custom format list

"bill" wrote:

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