| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel trying to sum a column of calculated values
"EdMac" wrote: Hi Rowdy, Why not do it the easy way! If all your times are 15 minutes you can just do it with numbers rather than time format - I tend to have problems with time. The boxes where you put text need to be formatted to wrap the text -Formatalignmentwrap text. In Col C the IF statement can either be in the form =IF(B4="",0,15) or =IF(B4<"",15,"") You can then sum the entries and divide by 60 to give hours. Any Good Ed -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=504440 Hey Ed Yep that actually works pretty well, wonder why it will sum a calculation of a number but not a calculation of a time? The newer the version of excel the more trouble it gives me. Oh yes the thing with the content of a cell I think must have like a 255 character max per cell or something like that, I haven't had time to count them but I did use the word wrap in format. I may be kinda rusty at excel but not that rusty. anyway thanks for your help and I will almost guarantee you I will be back with more questions. thanks again Rowdy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I fix values in cells calculated by formula in Excel | Excel Worksheet Functions | |||
| Can the sum of 1p + 3p be calculated in a column in Excel? | Excel Discussion (Misc queries) | |||
| Check COlumn - Excel VBA | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Duplicate & Zero Values in Lists (Excel 2003) | Excel Worksheet Functions | |||
Threaded Mode
