Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
What about adding up minutes and seconds, and stopping the minutes from rolling over into hours?
Posted by - NA - on 28 March 2006 05:46 AM
|
|
Solution: Make sure your data has a leading "0:", as in "0:10:23" for 10 minutes and 23 seconds. Then format your SUM cell as "[mm]:ss". This format will display "73:10" rather than "1:13:10" for one hour, thirteen minutes, ten seconds. | |
|
Comments (0)