Calculation help

[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!!!

 

[Bob Phillips]

Try

=F5/(I5*24)

 

[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

 

[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!!!

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