N Nick Aug 20, 2003 #1 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.
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.
R Rick Aug 20, 2003 #2 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.
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.
