Calculation help

N

Norm

I want to calculate production numbers
I have the actual production number in F5 (115 peices)
I have the time duration in I5 :)59)
I need the average per hour in J5
Can someone help please
If more info is required please let me know
Cheers!!!
 
R

Roger Govier

Hi Norm

Time is stored as fractions of a day (24 hours).
So
=F5/(I5*24)
Format J5 as General
Result is 116.95
 
D

Dianne

I want to calculate production numbers
I have the actual production number in F5 (115 peices)
I have the time duration in I5 :)59)
I need the average per hour in J5
Can someone help please
If more info is required please let me know
Cheers!!!
Click to expand...



Be sure F5 is number format, I5 is time format, J5 is h:ss and ente
this formula:
=AVERAGE(F5*59/60)
 
Top