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

--
HTH

Bob Phillips

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

"Nymand" wrote in message
...
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:

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)

"Alan" wrote in message
oups.com...
Custom format the cell where your answer is as dd:hh:mm:ss

Nymand wrote:
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???