I'm still stumped. I followed your instructions, painted the format through
the end of the column (including the results cell), and when I hit autosum, I
still get the message saying there's an error in the formula. Is it just me??

"BT" wrote:

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?