Minute/Second Format

[Mike]

I'm trying to use excel to chart the number of minutes
played in a game. I want to enter 40:00 to signify the
time remaining in the half etc. and then calculate the
time played by each player.

Thanks in advance.

 

[Frank Kabel]

Hi Mike
not quite sure but as a starting point for date/time calculations have
a look at
http://www.cpearson.com/excel/datetime.htm