Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting result cell for adding time
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting result cell for adding time
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting result cell for adding time
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting result cell for adding time
You didn't tell us what your formula was, so it is rather difficult for us
to tell you what your error is. -- David Biddulph "Carol" wrote in message ... 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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting result cell for adding time
Sorry, but I was using the AutoSum. The formula that it automatically
inserts is: =SUBTOTAL(9,) "David Biddulph" wrote: You didn't tell us what your formula was, so it is rather difficult for us to tell you what your error is. -- David Biddulph "Carol" wrote in message ... 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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting result cell for adding time
Until you tell us what your formula is, we can't tell you what the error in
the formula is. -- David Biddulph "Carol" wrote in message ... 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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting result cell for adding time
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. -- David Biddulph "Carol" wrote in message ... Sorry, but I was using the AutoSum. The formula that it automatically inserts is: =SUBTOTAL(9,) "David Biddulph" wrote: You didn't tell us what your formula was, so it is rather difficult for us to tell you what your error is. -- David Biddulph "Carol" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding colour to result in a cell? | Excel Discussion (Misc queries) | |||
Adding time to date-time formatted cell | Excel Discussion (Misc queries) | |||
adding time zones to formatting | Excel Worksheet Functions | |||
Conditional Formatting using result of Cell Formulas | Excel Discussion (Misc queries) | |||
Cell / Date Formatting Question when result = -0- | Excel Discussion (Misc queries) |