excel question

[shetuck]

=CONCATENATE((DAY(A5)),"d ",(HOUR((A5/24/60))),"hr ",(MINUTE(A5/24/60)),"min")

Putting in 2,000,000 gives: "23d 21hr 20min".

 

[AKAK]

=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)

 

[NJ-Buckeye]

dang.. an excel help line !?!?!? well worth the $49.99 I paid for the baptism

 

[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!

 

[BuckeyeNation27]

that's not an excellent question....it's a stupid question.

 

[jimotis4heisman]

thanks guys for all the help, everyone has been given greenies.

thanks very much!

 

[shetuck]

thanks guys for all the help, everyone has been given greenies.

thanks very much!

So how did you end up doing it?

[... and don't tell me "Go ask Thump"]

 

[PlanetFrnd]

=TIME(,200,) or =TIME(,[cell reference],)

 

[jimotis4heisman]

So how did you end up doing it?

[... and don't tell me "Go ask Thump"]

i printed off a version of both.

its for a presentation, i'll use it if im asked how i got those numbers. i'll same them down and say look here, i got shetuck/ironbuck/and scooter the parking nazi on my side...

 

[shetuck]

[email protected] gives free excel tutorials at www.edfinancial.com.

Username: leebrown
Password: mybestfriendhasmightymandibles

 

[Fungo Squiggly]

thanks guys for all the help, everyone has been given greenies.

thanks very much!

It's probably too late by now, but I hope the figures weren't TOO important since they are wrong. :p

=CONCATENATE((DAY(A5)),"d ",(HOUR((A5/24/60))),"hr ",(MINUTE(A5/24/60)),"min")

Putting in 2,000,000 gives: "23d 21hr 20min".

The "DAY" function only gives you a result up to 31, as in the day of the month, not the total number of days.

This formula:

=CONCATENATE(ROUNDDOWN(A5/1440, 0), ":",(HOUR((A5/24/60))),":",(MINUTE(A5/24/60)))

will give you the correct answer of 1388:21:20 (1388 days, 21 hours, and 20 minutes), where cell A5 is the inputted total number of minutes.