| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing minutes and seconds
I want to add minutes and seconds. It is entered into the worksheet as:
3:50 (this represents 3 minutes and 50 seconds) 0:45 (this represent 45 seconds) I've formatted the cells so they are mm:ss If I use a Sum function, it shows 35:00. I'm not sure what this is telling me. It should be 4:35 (4 minutes and 35 seconds). -- Lady |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change a minutes and seconds as a 2400 time to seconds? | Excel Worksheet Functions | |||
| Entering Seconds but displaying minutes & seconds | Excel Discussion (Misc queries) | |||
| Formula to Change Hours:Minutes:Seconds to Seconds only | Excel Discussion (Misc queries) | |||
| Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
| Convert seconds to minutes and seconds in excel | Excel Worksheet Functions | |||
Threaded Mode
