Time conversion & adding

[mpenkala]

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

 

[muddan madhu]

try [m] in format cell | numbers |custom

 

[Mike H]

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

 

[David Biddulph]

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

 

[mpenkala]

Hey David,

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

Matt

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

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

 

[David Biddulph]

Glad it worked for you.
--
David Biddulph

Hey David,

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

Matt

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

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