display minutes and seconds in excel
 

I'm trying to build a spreadsheet to help me track and analyze football
stats. Everytime I try to type in a time (i.e., the TD happened at 6:08) it
always changes my format and gives me a random figure. I tried setting the
format to mm:ss, but still similar results. If at all possible, I'd like to
eventually set the worksheet to look at each line, and if its labeled with a
K (for Knights) it will move the time figure into another column and give me
a total at the end of the game (i.e., Knights had the ball 34:43; Kangaroos
had the ball 25:35).
Any ideas?

Excel assumes your 6:08 is h:mm. If you enter 0:6:8 and format as mm:ss you
will get 06:08.

On your second question, assuming times are in A and "K" is in B. In C type
=IF(B2="K",A2,"") and copy down.

--
Ian
--
"Jonathan Blundell" <Jonathan wrote in
message ...
I'm trying to build a spreadsheet to help me track and analyze football
stats. Everytime I try to type in a time (i.e., the TD happened at 6:08)
it
always changes my format and gives me a random figure. I tried setting the
format to mm:ss, but still similar results. If at all possible, I'd like
to
eventually set the worksheet to look at each line, and if its labeled with
a
K (for Knights) it will move the time figure into another column and give
me
a total at the end of the game (i.e., Knights had the ball 34:43;
Kangaroos
had the ball 25:35).
Any ideas?