If you use time format e.g the custom format I showed then enter a time like
0:36:00
36 and using time format means that excel sees it as 36 days after Jan 0
1900 or 36x24x60 minutes
Use 0:36:00, if you use 36 use General format

--


Regards,

Peo Sjoblom

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


"tjsmags" wrote in message
...
I formatted the cell (I used the Custom mm:ss, but I changed it to show
your
formula of [mm]:ss). But, when I enter a number, like 36, it shows in the
formula bar a date plus time that doesn't make sense. And, in the cell it
shows a huge number, like 51840:00. How am I, exactly, to enter the
minutes
of, say, 36 or 27 or 9, etc?

"Peo Sjoblom" wrote:

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?