View Single Post
  #6   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

format your cells to [h]:mm:ss.
(right click cell - format cells - custom - [h]:mm:ss bottom of the 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