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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top