Turning numbers into days, hours and minutes
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???
|