| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sum increments of minutes and seconds
I have an excel spreadsheet that has time entered in for minutes and
seconds; ie 7 minutes and 28 seconds is shown as 7.28. How do I sum a column with increments of time. example: 7.28 (7 minutes & 28 seconds) 2.38 (2 minutes & 38 seconds) 5.48 (5 minutes & 48 seconds) Total time should result in 15.54 (15 minutes & 54 seconds), but if I do a simple SUM, the results are 15.14. HELP! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding minutes & seconds | Excel Discussion (Misc queries) | |||
| Formatting minutes and seconds to calculate a total average | Excel Worksheet Functions | |||
| Sum minutes and seconds to total hours | Excel Discussion (Misc queries) | |||
| how do I add minutes and seconds together in excel | Excel Worksheet Functions | |||
| convert seconds to minutes and seconds | Excel Worksheet Functions | |||
Threaded Mode
