# Formatting result cell for adding time

C

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

B

#### 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.

C

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

BT said:
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 said:
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?

D

#### 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.

C

#### Carol

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

D

#### David Biddulph

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

Carol said:
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 said:
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 said:
I have a column of numbers formatted as h:mm and I want a sum. I have
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?

D

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