Turning numbers into days, hours and minutes
 

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???

Turning numbers into days, hours and minutes
 

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???

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???

Turning numbers into days, hours and minutes
 

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???

Turning numbers into days, hours and minutes
 

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???

Turning numbers into days, hours and minutes
 

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:

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???

Turning numbers into days, hours and minutes
 

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)

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

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???

Turning numbers into days, hours and minutes
 

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:

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)

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

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???