Turning numbers into days, hours and minutes

[Guest]

Hello,

To keep it short and simple:

I have 4220 lbs of grain and I can only unload 2000 lbs a day. I divide the
number and end up with 2,1100 work days. How is it possible to have excel
write the days, hours and minutes as I can only get it to write the hours and
minutes used. 4220/2000 = 2,11 days = 02h:38m:24s. The time spend is the
same if I only write ,11.. Is it even possible for Excel to do this? Or am I
supposed to just write the days in myself and let excel do the rest???

 

[Alan]

Custom format the cell where your answer is as dd:hh:mm:ss

 

[Bob Phillips]

I would use d "days" h:mm:ss, but beware, this only works up to 31 days.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Hello,

I'm not exactly sure what you and Alan mean!
The "box" with the result. Am I supposed to right-click and find what I'm
looking for there? I'm not sure I know how to custom format the cell. I can't
seem to find both the days and the hours used..

"Bob Phillips" skrev:

 

[Bob Phillips]

In the 'cell' that the result is in (=4220/2000 or maybe =A1/B1), select
that cell, got to menu Format>Cells>Custom, and add one of the formats we
gave.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

So far so good, I found the place because of you guys,but I can't seem to use
both days and hours.. If I use one of them, I end up with this result:
02:h:38:24. Now I only need to have 2 written where the "h" is..


"Bob Phillips" skrev:

 

[Bob Phillips]

You have entered an incorrect format then, there should be no h.

Try again with d "days" h:mm:ss

including the "

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

2 days hh:38:24 This is actually what I can come up with.. Guess it's a
step further. Whether I make it with one H or two doesn't make a difference..
Could you please write exactly what I need to write. Word for word... and
nothing else.. Don't know if that'll help me but guess that's all I can
manage..


"Bob Phillips" skrev:

 

[Bob Phillips]

Okay, this is how I did it.

In cell A1, I entered =4220/2000 (at this point it shows 2.11)

I went to menu Format
From here I selected Cells
From the Category list I selected Custom (bottom item)
In the type field on the right I entered d "days" h:mm:ss
Hit the OK button

A1 now shows 2 days 2:38:24

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[trice-nae]

Just my 2 cents, but in the example you give, it doesn't sound like you
need the seconds. In the number format box (described above), I'd type:

d "days" h:mm

in which case your result would read: 2 days 2:38

You could also do:

d "days," h "hours," m "min"

in which case your result would read: 2 days, 2 hours, 38 min

or maybe

d"d" h"h" m"m"

which would yield: 2d 2h 38m

I think I like the last one the best.