Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I total a column with hours and minutes? SUM doesnt work
I have 5 rows of figures which are the result of computing hours and minutes
in each row. I want to total this column and used the formula =SUM(d4:d8) for the target cell and I get zeros as my answer. No warnings or errors. The target cell of the sum is formatted to time. What am I doing wrong? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I total a column with hours and minutes? SUM doesnt work
If d4:d8 contains text (which = 0) then sum(d4:d8) will equal 0.
Rmember that formatting doesn't mean anything if the underlying data is not what you expect it to be. HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "ken gates" wrote: I have 5 rows of figures which are the result of computing hours and minutes in each row. I want to total this column and used the formula =SUM(d4:d8) for the target cell and I get zeros as my answer. No warnings or errors. The target cell of the sum is formatted to time. What am I doing wrong? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I total a column with hours and minutes? SUM doesnt work
Gary,
Thanks for the response. How do I take these "text" hours and minutes and make them numeric so I can add them, and then what do I have to do to convert them back to hours and minutes after the math has been done? "ken gates" wrote: I have 5 rows of figures which are the result of computing hours and minutes in each row. I want to total this column and used the formula =SUM(d4:d8) for the target cell and I get zeros as my answer. No warnings or errors. The target cell of the sum is formatted to time. What am I doing wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins? | Excel Discussion (Misc queries) | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
Sum minutes and seconds to total hours | Excel Discussion (Misc queries) | |||
sum total hours and minutes | Excel Discussion (Misc queries) | |||
add column of minutes, show total in hours & minutes | Excel Worksheet Functions |