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
|