In creating a soccer scorecard I would like to figure out how to display on
the scorecard minutes played during a game. Our soccer team plays four 9
minute quarters (36 minutes total). I want to display for each player the
time IN and OUT and then TOTAL minutes played. But, I don't want Excel to
convert this into ACTUAL time (as in time of day).

For example, I want the spreadsheet to show Player A started the 1st quarter
at 36 minutes. He substituted out at 29 minutes (so he played 7 minutes in
the 1st quarter). He started the 2nd qtr at 27 minutes and then sub out at
22 minutes. He started the 3rd qtr at 18 minutes and played the entire qtr.
He started the last qtr at 9 minutes and sub out at 2 minutes. I want it to
show all the MINUTES and then grand total the TOTAL minutes played.

I can't figure out how to format the cell and then how to input the minutes.
I would like to see 36:00, 29:00, 27:00, 22:00, 18:00, 09:00, 02:00. Is
this possible?