Formatting result cell for adding time

  • Thread starter Thread starter Carol
  • Start date Start date
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?
 
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'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?
 
You didn't tell us what your formula was, so it is rather difficult for us
to tell you what your error is.
 
Sorry, but I was using the AutoSum. The formula that it automatically
inserts is: =SUBTOTAL(9,)
 
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
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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top