![]() |
|
#4
|
||||
|
||||
|
There's only one reason I see that the value in cell F87 is wrong; it not summing the right range. The formula is currently:
=SUM(F85:F86) A better formula would be: =SUM(F54:F84) which gives 4 hours, 50 minutes and 4 seconds If there's a possibility that the time summed exceeds 24 hours you'd be better formatting that cell with custom format: [h]:mm:ss with the square brackets enabling the display of hour values greater than 24. If you select the single cell where you want the sum to appear, away from other cells containing data, then click the sum symbol, you'll get just =SUM(|) in the cell with the cursor sitting within the parentheses, do nothing except select the cells you want summing and press Enter on the keyboard. The only difference from what you were doing is now you're selecting (highlighting) the cells you want to sum after clicking the sum symbol rather than before clicking it. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Cannot get latest Office Updates for Office 2007, Using Windows 7 Home Premium | DLD1100 | Office | 1 | 12-01-2022 12:12 AM |
| Run-time error in VB.NET program that worked under Office XP but quit when upgraded to Office 2007 | Dick_in_Dallas | Misc | 0 | 03-14-2015 07:07 PM |
| Proper Procedure for updating Office 2000 to Office 2007 Professional | stevetag | Office | 5 | 08-03-2012 02:47 AM |
| Using Korean language dictionary from Office 2007 on Office 2011 doable? | kylera | Office | 0 | 07-10-2012 02:12 AM |
| Using Office Premium 2007 Trial with Already Installed Office Home and Student 2007 | SME | Office | 1 | 10-07-2009 06:51 AM |