I need to work out some statistics to determine the average time students take to complete a test. I can do the conversion from minutes and seconds to just minutes for each student which is easy however I need to then add the total time taken by all students divided by the number of students and then (this is the issue) convert that average time back to hours minutes and seconds. I can achieve this by using multiple columns but it would be much more efficient if I could just use a single formula that would allow input of time taken to be entered into just one cell.
I am currently able to take a number of times in the format 19m 12s and convert to seconds then calculate the average however it leaves me with a format of 6.78333333 which I now need to convert back to the original input format.