Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need to add a long list of minutes and seconds. (ex. 25:16, 16:39, 27:41)
I have looked at all the functions and cannot find one that works. They all want to add the times assuming they are hours and minutes or time on a clock. I want to find a function that would add up the previous example and display it as 69:36 total minutes and seconds. It seems like one of the problems I am running into is finding or creating my own function that knows to add up the seconds to 60, not 100 like most decimal functions are used to. Does anyone have an answer? I would be forever grateful! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting minutes and seconds to calculate a total average | Excel Worksheet Functions | |||
Sum minutes and seconds to total hours | Excel Discussion (Misc queries) | |||
Create a custom format to convert seconds to minutes. | Excel Discussion (Misc queries) | |||
Adding minutes to time | Excel Discussion (Misc queries) | |||
convert seconds to minutes and seconds | Excel Worksheet Functions |