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?