Hi Carol
Easy way to do this is to select the first time in your list and select
Format / Cells. select Custom format, and select the hh:mm format. Add square
brackets round the hours - [hh]:mm - and OK. Select Format Painter and copy
the format down your column of numbers, and autosum will give you a total of
the hours and minutes.

"Carol" wrote:

I have a column of numbers formatted as h:mm and I want a sum. I have read
the posts about formatting the result cell with brackets around the h. When
I do this, and use the autosum button, I get the pop-up message that there is
an error in my formula. Any suggestions?