 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Time 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 try [m] in format cell | numbers |custom On May 28, 9:36 pm, mpenkala <mpenk...@discussions.microsoft.com> wrote: > Hi there, > [quoted text clipped - 21 lines] > Thanks a bunch! > Matt 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 > Hi there, > [quoted text clipped - 21 lines] > Thanks a bunch! > Matt Format as [m] if you just want to see 120, or [m]:ss if you want 120:00 -- David Biddulph > Hi there, > [quoted text clipped - 25 lines] > Thanks a bunch! > Matt 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 > -- [quoted text clipped - 29 lines] > > Thanks a bunch! > > Matt Glad it worked for you. -- David Biddulph > Hey David, > [quoted text clipped - 39 lines] >> > Thanks a bunch! >> > Matt |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.