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