Format as [m] if you just want to see 120, or [m]:ss if you want 120:00
--
David Biddulph

"mpenkala" wrote in message
...
Hi there,

I have a stats sheet that records how many minutes a basketball player
plays
during a game. This same sheet also tracks each game, so I have a column
that shows playing time for numerous games:

ColU
21:22.0
42:51.0
36:00.0
36:00.0
12:00.0

I have formatted it as mm:ss.0 since this was the only way I could get
them
to all add up (In cell X9 I have =SUM(U3:U14) and it is formatted as
h:mm:ss
(since if I format it as mm:ss.0 it only gives me the minutes and seconds,
not the hours).

What I'm looking for is:
1 - Display total playing time (in X9) in minutes only (so 24 minutes of
playing time in 6 games would be a total of 120 mins of total playing
time)
instead of showing it as I currently have it set up (2:00:00)

Thanks a bunch!
Matt