Formatting Cells

[Nick]

I am looking to format a cell for time. Not time of day
but a duration. Example, I ran the race in 9 minutes 36
seconds.

 

[Rick]

Put the 00:09:30 in a cell then use the minute & second
function in the two cells next to it refering to that
time. I hope this helps.