I need to average some durations recorded in the format minutes:seconds. They were originally numbers formatted as text.
I have formatted the cells as mm:ss. I need a formula similar to =timevalue to convert the data to serials, but =timevalue gives me a 24-hour clock value, rather than minutes and seconds.
Any suggestions?
I have formatted the cells as mm:ss. I need a formula similar to =timevalue to convert the data to serials, but =timevalue gives me a 24-hour clock value, rather than minutes and seconds.
Any suggestions?