Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Conversion | Excel Discussion (Misc queries) | |||
time conversion | Excel Discussion (Misc queries) | |||
Time Conversion | Excel Discussion (Misc queries) | |||
Time conversion | Excel Worksheet Functions | |||
Time conversion | Excel Discussion (Misc queries) |