• 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
jimotis4heisman

jimotis4heisman

Banned
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...
 
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
 
Upvote 0
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.
 
Upvote 0
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...

fucking brilliant
 
Upvote 0
You must log in or register to reply here.
Back
Top