| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correct Time Sum, by Formulas. Help Please.
In Excel97, I have the following times i would like to sum.
(Minutes:Seconds:Seconds/100). A ------------- 1 07:56:07 ------------- 2 05:22:76 ------------- 3 05:14:84 ------------- 4 05:41:51 ------------- 5 05:14:01 ------------- 6 05:28:25 ------------- 7 07:56:37 ------------- ------------- 8 41:33:81 If i sum, i get 41:33:81, but the correct result for this case is 42:53:81 (Minutes:Seconds:Seconds/100). I would like the result to be in one single cell, that in this case is cell A8. What formula should i write in cell A8 ? Any Help appreciated. Robert. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas showing as correct but not working | Excel Worksheet Functions | |||
| Subtract hours from a time and get the correct time | Excel Worksheet Functions | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| Can you please hel me to find the correct formulas | Excel Worksheet Functions | |||
| F9 flips formulas between zero and correct value | Excel Discussion (Misc queries) | |||
Threaded Mode
