Time conversion & adding
 

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

Time conversion & adding
 

try [m] in format cell | numbers |custom




On May 28, 9:36*pm, mpenkala
wrote:
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

Time conversion & adding
 

Hi,

I would hope playing 6 games of 24 minutes each gave 144 minutes ;)

With your time in column U formatted as hh:mm:ss try this in X9

=SUM(U1:U6)*1440

Formatted as general you should get 144

Mike


"mpenkala" wrote:

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

Time conversion & adding
 

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

Time conversion & adding
 

Hey David,

this one worked the best, thanks! All the other suggestions also worked!
Thanks guys/gals!

Matt


"David Biddulph" wrote:

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

Time conversion & adding
 

Glad it worked for you.
--
David Biddulph

"mpenkala" wrote in message
...
Hey David,

this one worked the best, thanks! All the other suggestions also worked!
Thanks guys/gals!

Matt


"David Biddulph" wrote:

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