Formatting result cell for adding time

[Carol]

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?

 

[BT]

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]

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??

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.

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?

 

[David Biddulph]

You didn't tell us what your formula was, so it is rather difficult for us
to tell you what your error is.

 

[Carol]

Sorry, but I was using the AutoSum. The formula that it automatically
inserts is: =SUBTOTAL(9,)

 

[David Biddulph]

Until you tell us what your formula is, we can't tell you what the error in
the formula is.
--
David Biddulph

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??

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.

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?

 

[David Biddulph]

So that tells you the problem. If you look at help for the SUBTOTAL
function, it wants 2 arguments, the second of which is the range that you
want to total. In your case, that argument is missing. I would normally
use the SUM function, rather than SUBTOTAL, but I don't know the structure
of your data.