• Follow us on Twitter @buckeyeplanet and @bp_recruiting, like us on Facebook! Enjoy a post or article, recommend it to others! BP is only as strong as its community, and we only promote by word of mouth, so share away!
  • Consider registering! Fewer and higher quality ads, no emails you don't want, access to all the forums, download game torrents, private messages, polls, Sportsbook, etc. Even if you just want to lurk, there are a lot of good reasons to register!

excel question

Jump to latest Follow Reply
Sort by date Sort by votes
shetuck;1253923; said:
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.
Click to expand...

holy shit, 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
 
Upvote 0
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).
 
Upvote 0
iambrutus;1253930; said:
holy shit, 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
Click to expand...

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...

JoseVillaRaulHerrera.jpg
 
Upvote 0
You must log in or register to reply here.
Back
Top