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