Why don't you just use integers and subtract, start in A1, subbed in B1

=A1-B1

Or use the same formula, custom format as [mm]:ss

then enter the times as 0:36:00 and 0:27:00

Then total and =SUM(Range) and use the same custom format

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email)


"tjsmags" wrote in message
...
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?