I am trying to calculate duration of minutes and seconds. I want to calculate start time: 3:39 (m:ss) to end time: 5:22 (m:ss) but excel keeps converting it to AM/PM time. If I format it as h:mm:ss and type in those values excel tells me ####.
Solved by F. A. in 13 mins