One way:

=SUM(A1:A1000)

Format the cell with Format/Cells/Number/Custom [h]:mm

or another time format. The brackets keep the value from rolling over
(e.g., 25 hours will appear as 25:00 rather than 1:00).


In article ,
Sandra wrote:

Can anyone help me calculate time. I simply want to add a column of
minutes spent to determine total duration.