| Computers, Home Theater & Technology Need help with your computer? Want to learn about the latest advances in technology? Are you an audio/videophile? Need help hooking up your home theater? This is the forum for you. |
09-09-2008, 09:50 AM
|
 |
Head Coach
|
|
|
|
Join Date: Apr 2004
Posts: 9,878
Points: 270,760.10
Bank: 0.00
Total Points: 270,760.10
|
|
|
excel question
id like to format something in excel.
basically the inputs are for expample 200 minutes.
I would like to format so it says 3hr 20min
greenies to the first person to know how to do it an explain it in a way i can understand...
|
09-09-2008, 10:04 AM
|
 |
Go Bucks/Hail to the Redskins!!
|
|
|
|
Join Date: Jun 2003
Posts: 1,231
Points: 228,710.85
Bank: 128,696.48
Total Points: 357,407.33
|
|
I found this link on the web and thought I'd let you take a look at it instead of me trying to explain it to you. Hope it helps.
Excel Function - Excel CONVERT Function - Excel 2007 CONVERT Function |
09-09-2008, 10:13 AM
|
 |
misunderestimated
|
|
|
|
Join Date: Apr 2004
Posts: 4,508
Points: 4,359,328.55
Bank: 91.02
Total Points: 4,359,419.58
|
|
|
enter 0:200
right-click
format cells
number tab
time
37:30:55
Any number off minutes entered in as 0:{number of minutes} will give you an hours and minutes result.
__________________
|
09-09-2008, 10:17 AM
|
 |
Crazy Bearded Fool
|
|
|
|
Join Date: Aug 2004
Posts: 14,744
Points: 76,183.35
Bank: 0.00
Total Points: 76,183.35
|
|
|
Closest thing I can come up with is to use the formula A1/1440 and set the field to hh:mm
Put the formula in the field you want the hh:mmm to appear and enter the total minutes in the field represented in the formula.
so for formula A1/1440, enter 200 in A1 and format the cell with the formula to hh:mm it will show 3:20
|
09-09-2008, 10:24 AM
|
|
Head Coach
|
|
|
|
Join Date: Apr 2004
Posts: 9,878
Points: 270,760.10
Bank: 0.00
Total Points: 270,760.10
|
|
|
that's what i thought, what if it is greater than 24 hours?
|
09-09-2008, 10:30 AM
|
|
misunderestimated
|
|
|
|
Join Date: Apr 2004
Posts: 4,508
Points: 4,359,328.55
Bank: 91.02
Total Points: 4,359,419.58
|
|
Quote:
Originally Posted by jimotis4heisman
that's what i thought, what if it is greater than 24 hours?
|
scooter's formula with the format set for 37:30:55 will give you 3:20:00 with 200 minutes as the input and 33:20:00 with 200 minutes as the input.
__________________
|
09-09-2008, 10:36 AM
|
|
Head Coach
|
|
|
|
Join Date: Apr 2004
Posts: 9,878
Points: 270,760.10
Bank: 0.00
Total Points: 270,760.10
|
|
|
ok i over simplified and created more issues
how do i make 2,000,000 mins read out in hours:mins?
|
09-09-2008, 10:38 AM
|
|
Crazy Bearded Fool
|
|
|
|
Join Date: Aug 2004
Posts: 14,744
Points: 76,183.35
Bank: 0.00
Total Points: 76,183.35
| | |
