Formula for time
 

Hi
I need to calculate the production time for a partcular machine.
A1= quantity to produce= 4,800
B1= production/hour= 200
C1= production time= A1/B1 returns 00:00 (format is hh:mm), not 24:00 hours.
Could somebody help me with that?
Thank you and happy new year!

Hi
format the cell with the custom format
[hh]:mm

--
Regards
Frank Kabel
Frankfurt, Germany
"DMachado" schrieb im Newsbeitrag
...
Hi
I need to calculate the production time for a partcular machine.
A1= quantity to produce= 4,800
B1= production/hour= 200
C1= production time= A1/B1 returns 00:00 (format is hh:mm), not 24:00
hours.
Could somebody help me with that?
Thank you and happy new year!

On Fri, 31 Dec 2004 13:07:01 -0800, "DMachado" wrote:

Hi
I need to calculate the production time for a partcular machine.
A1= quantity to produce= 4,800
B1= production/hour= 200
C1= production time= A1/B1 returns 00:00 (format is hh:mm), not 24:00 hours.
Could somebody help me with that?
Thank you and happy new year!

If you want to use the Excel time format, then you need to know that Excel
represents days as integers. So 1 day = 1 = 24 hours.

In addition, because of the formatting, you need to put the h in brackets in
order to prevent it from rolling over to zero every 24 hours.

So to get the value you want, in Excel time format, you need to divide your
formula result by 24 (so hours are represented as the appropriate fraction of a
day); and then change your format to [hh]:mm or [h]:mm

C1= A1/B1/24


--ron

I have been struggling a bit working with time.

This explanation of the necessity to divide by 24 is very clear.
Can someone post an explanation of the function of the brackets in the
time format [hh]:mm.

Many thanks and happy New Year to all, especially those very generous
posters that tirelessly answer all our questions.


Ron Rosenfeld wrote:
On Fri, 31 Dec 2004 13:07:01 -0800, "DMachado"
wrote:

Hi
I need to calculate the production time for a partcular machine.
A1= quantity to produce= 4,800
B1= production/hour= 200
C1= production time= A1/B1 returns 00:00 (format is hh:mm), not
24:00 hours.
Could somebody help me with that?
Thank you and happy new year!

If you want to use the Excel time format, then you need to know that
Excel
represents days as integers. So 1 day = 1 = 24 hours.

In addition, because of the formatting, you need to put the h in
brackets in
order to prevent it from rolling over to zero every 24 hours.

So to get the value you want, in Excel time format, you need to
divide your
formula result by 24 (so hours are represented as the appropriate
fraction of a
day); and then change your format to [hh]:mm or [h]:mm

C1= A1/B1/24


--ron

If you *re-read* Ron's post, he very clearly states the reason for the
brackets:

<"In addition, because of the formatting, you need to put the h in brackets
in
order to prevent it from rolling over to zero every 24 hours."

60 minutes to an hour
24 hours to a day

dd:hh:mm
With the above format, every 60 minutes, the minutes zero out, and the hour
increments up 1.
Every 24 hours, the hours zero out, and the day increments up 1.

BUT ... If the format is:
hh:mm
When the minutes zero out and the day increments up 1, your format *doesn't*
show the day total, just the zeroed out minutes.
All the numbers are there, you just hide them with your format.

So, the brackets *prevent* the minutes from zeroing out when the days are
incremented up 1.
[hh]:mm

Try this format:
dd:[hh]:mm
And you'll see what I mean.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Paul" wrote in message
ps.com...
I have been struggling a bit working with time.

This explanation of the necessity to divide by 24 is very clear.
Can someone post an explanation of the function of the brackets in the
time format [hh]:mm.

Many thanks and happy New Year to all, especially those very generous
posters that tirelessly answer all our questions.


Ron Rosenfeld wrote:
On Fri, 31 Dec 2004 13:07:01 -0800, "DMachado"
wrote:

Hi
I need to calculate the production time for a partcular machine.
A1= quantity to produce= 4,800
B1= production/hour= 200
C1= production time= A1/B1 returns 00:00 (format is hh:mm), not
24:00 hours.
Could somebody help me with that?
Thank you and happy new year!

If you want to use the Excel time format, then you need to know that
Excel
represents days as integers. So 1 day = 1 = 24 hours.

In addition, because of the formatting, you need to put the h in
brackets in
order to prevent it from rolling over to zero every 24 hours.

So to get the value you want, in Excel time format, you need to
divide your
formula result by 24 (so hours are represented as the appropriate
fraction of a
day); and then change your format to [hh]:mm or [h]:mm

C1= A1/B1/24


--ron

Needless to say, last night was a bummer, and I'm still recovering!

I *meant* to say hours instead of minutes in my previous post.

BUT ... If the format is:
hh:mm
When the HOURS zero out and the day increments up 1, your format *doesn't*
show the day total, just the zeroed out HOURS.
All the numbers are there, you just hide them with your format.

So, the brackets *prevent* the HOURS from zeroing out when the days are
incremented up 1.
[hh]:mm
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Ragdyer" wrote in message
...
If you *re-read* Ron's post, he very clearly states the reason for the
brackets:

<"In addition, because of the formatting, you need to put the h in
brackets
in
order to prevent it from rolling over to zero every 24 hours."

60 minutes to an hour
24 hours to a day

dd:hh:mm
With the above format, every 60 minutes, the minutes zero out, and the
hour
increments up 1.
Every 24 hours, the hours zero out, and the day increments up 1.

BUT ... If the format is:
hh:mm
When the minutes zero out and the day increments up 1, your format
*doesn't*
show the day total, just the zeroed out minutes.
All the numbers are there, you just hide them with your format.

So, the brackets *prevent* the minutes from zeroing out when the days are
incremented up 1.
[hh]:mm

Try this format:
dd:[hh]:mm
And you'll see what I mean.
--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-

"Paul" wrote in message
ps.com...
I have been struggling a bit working with time.

This explanation of the necessity to divide by 24 is very clear.
Can someone post an explanation of the function of the brackets in the
time format [hh]:mm.

Many thanks and happy New Year to all, especially those very generous
posters that tirelessly answer all our questions.


Ron Rosenfeld wrote:
On Fri, 31 Dec 2004 13:07:01 -0800, "DMachado"
wrote:

Hi
I need to calculate the production time for a partcular machine.
A1= quantity to produce= 4,800
B1= production/hour= 200
C1= production time= A1/B1 returns 00:00 (format is hh:mm), not
24:00 hours.
Could somebody help me with that?
Thank you and happy new year!

If you want to use the Excel time format, then you need to know that
Excel
represents days as integers. So 1 day = 1 = 24 hours.

In addition, because of the formatting, you need to put the h in
brackets in
order to prevent it from rolling over to zero every 24 hours.

So to get the value you want, in Excel time format, you need to
divide your
formula result by 24 (so hours are represented as the appropriate
fraction of a
day); and then change your format to [hh]:mm or [h]:mm

C1= A1/B1/24


--ron

On 1 Jan 2005 07:16:18 -0800, "Paul" wrote:

This explanation of the necessity to divide by 24 is very clear.
Can someone post an explanation of the function of the brackets in the
time format [hh]:mm.

As I wrote, it keeps the hours from rolling over to zero every 24 hours.
Perhaps this example will make it more clear:

Value Format Display
=12/24 d:h:m 0:12:0
=12/24 h:m 12:0

1.5 d:h:m 1:12:0
1.5 h:m 12:0
1.5 [h]:m 36:0


--ron

Thank you all for you time, on New Years Day.
It is all very clear to me now.

I wish you all a very happy, safe and successful 2005.

Ron Rosenfeld wrote:
On 1 Jan 2005 07:16:18 -0800, "Paul" wrote:

This explanation of the necessity to divide by 24 is very clear.
Can someone post an explanation of the function of the brackets in
the
time format [hh]:mm.

As I wrote, it keeps the hours from rolling over to zero every 24
hours.
Perhaps this example will make it more clear:

Value Format Display
=12/24 d:h:m 0:12:0
=12/24 h:m 12:0

1.5 d:h:m 1:12:0
1.5 h:m 12:0
1.5 [h]:m 36:0


--ron