Calculation help

  • Thread starter Thread starter Norm
  • Start date Start date
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!!!
 
Hi Norm

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