| 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, 11:43 AM
|
 |
Embedded In Country
|
|
|
|
Join Date: Sep 2007
Posts: 5,193
Points: 1,511,059.81
Bank: 0.00
Total Points: 1,511,059.81
|
|
|
=CONCATENATE((DAY(A5)),"d ",(HOUR((A5/24/60))),"hr ",(MINUTE(A5/24/60)),"min")
Putting in 2,000,000 gives: "23d 21hr 20min".
__________________
"good gooblie goo"
|
09-09-2008, 11:45 AM
|
 |
Schwarze Kapelle
Bookmaker
|
|
|
|
Join Date: Jun 2003
Posts: 10,758
Points: 1,921,770.67
Bank: 0.00
Total Points: 1,921,770.68
|
|
|
=CONVERT(A01, "mn","day")
Where A01 is the cell with your minutes, then custom format it to dd:hh:mm (or whatever scooter's thing was)
__________________
You're a daisy if you do.
|
09-09-2008, 11:46 AM
|
 |
Italy - World Cup Champs !!!
Moderator
|
|
|
|
Join Date: Jul 2004
Posts: 4,403
Points: 3,114.69
Bank: 0.00
Total Points: 3,114.69
|
|
|
dang.. an excel help line !?!?!? well worth the $49.99 I paid for the baptism
__________________
* ESPN announcer -- "at the .6 yards per carry Iowa is gaining, it would take 17 carries to get a first down"
* Brett Favre -- "they pay me to practice and off season work..I do game day for free"
* "If you visit Ohio State, there's nothing to dislike about the place," said Gateway coach Terry Smith. "They get 100,000 fans. They played for the national championship three of the last five years. They put kids in the pros."
|
09-09-2008, 11:50 AM
|
|
Embedded In Country
|
|
|
|
Join Date: Sep 2007
Posts: 5,193
Points: 1,511,059.81
Bank: 0.00
Total Points: 1,511,059.81
|
|
Quote:
Originally Posted by shetuck
=CONCATENATE((DAY(A5)),"d ",(HOUR((A5/24/60))),"hr ",(MINUTE(A5/24/60)),"min")
Putting in 2,000,000 gives: "23d 21hr 20min".
|
Yep... I'm sure this one's right because when I put in "Tressel", I get "Value!" as the answer! 
__________________
"good gooblie goo"
|
09-09-2008, 11:55 AM
|
 |
Inside the Matrix
Moderator
|
|
|
|
Join Date: Apr 2004
Posts: 16,566
Points: 6,379.86
Bank: 0.00
Total Points: 6,379.86
|
|
|
that's not an excellent question....it's a stupid question.
|
09-09-2008, 11:55 AM
|
 |
Head Coach
|
|
|
|
Join Date: Apr 2004
Posts: 9,878
Points: 270,760.00
Bank: 0.00
Total Points: 270,760.00
|
|
thanks guys for all the help, everyone has been given greenies.
thanks very much!
 |
09-09-2008, 11:57 AM
|
|
Embedded In Country
|
|
|
|
Join Date: Sep 2007
Posts: 5,193
Points: 1,511,059.81
Bank: 0.00
Total Points: 1,511,059.81
|
|
|
