| 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, 10:48 AM
|
 |
Embedded In Country
|
|
|
|
Join Date: Sep 2007
Posts: 5,193
Points: 1,511,060.31
Bank: 0.00
Total Points: 1,511,060.31
|
|
Quote:
Originally Posted by scooter1369
[censored]ing elitist
|
Fixed... 
__________________
"good gooblie goo"
|
09-09-2008, 10:48 AM
|
 |
Head Coach
|
|
|
|
Join Date: Apr 2004
Posts: 9,878
Points: 270,760.65
Bank: 0.00
Total Points: 270,760.65
|
|
|
ok this is exactly what i have
in cell A1 =2,000,000/1440 (formatted hh:mm) i get 21:20 (displayed on my screen)
i know im like one step off where is it!!! ahhh, ps thank you so much guys
|
09-09-2008, 10:52 AM
|
 |
there's no dollar sign on a piece of mind
|
|
|
|
Join Date: Sep 2004
Posts: 11,274
Points: 1,632,517.97
Bank: 0.00
Total Points: 1,632,517.97
|
|
Quote:
Originally Posted by shetuck
Try this excel formula:
=CONCATENATE((HOUR((A5/24/60))),"hr ",(MINUTE(A5/24/60)),"min")
The number of minutes (e.g. 200) is in cell A5 (or whatever other cell).
If you put 200 in A5, what the formular yields is: "3hr 20min".
EDIT: I think you'll be able to use this formula without any special field/cell formatting.
|
holy [censored], you can do more than just track down trolls info in the interwebs - pretty soon espn is going to crown you superman and have to take tim tebows cock out of their mouthes
__________________
|
09-09-2008, 10:53 AM
|
|
Embedded In Country
|
|
|
|
Join Date: Sep 2007
Posts: 5,193
Points: 1,511,060.31
Bank: 0.00
Total Points: 1,511,060.31
|
|
|
Captain Obvious here...
I'm not doing anything basically different from Scooter with my formula other than the cat function and the built-in formatting.
In my formula I'm divinding the minutes by 24 (hours in a day) then by 60 (minutes in an hour). Scooter says divide the number of minutes by 1440 (which is 24*60).
__________________
"good gooblie goo"
|
09-09-2008, 10:55 AM
|
|
Head Coach
|
|
|
|
Join Date: Apr 2004
Posts: 9,878
Points: 270,760.65
Bank: 0.00
Total Points: 270,760.65
|
|
|
but, im limited again at 21 hr 20min...
right?
|
09-09-2008, 10:58 AM
|
|
Embedded In Country
|
|
|
|
Join Date: Sep 2007
Posts: 5,193
Points: 1,511,060.31
Bank: 0.00
Total Points: 1,511,060.31
|
|
Quote:
Originally Posted by iambrutus
holy [censored], you can do more than just track down trolls info in the interwebs - pretty soon espn is going to crown you superman and have to take tim tebows cock out of their mouthes
|
Chuck Norris was my FORTRAN structured programming instructor...
Well... actually it was Prof. Raul Herrera (in Engineering Graphics gwan-forty-gwan) back in the day in Hitchcock lab, but it's all good...
__________________
"good gooblie goo"
|
09-09-2008, 10:59 AM
|
|
Embedded In Country
|
|
|
|
Join Date: Sep 2007
Posts: 5,193
Points: 1,511,060.31
Bank: 0.00
Total Points: 1,511,060.31
|
|
|
| |
