ExcelBanter - Calculation help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Calculation help (https://www.excelbanter.com/excel-discussion-misc-queries/261632-calculation-help.html)

Norm

Calculation help

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[_4_]

Calculation help

Try

=F5/(I5*24)

--

HTH

Bob

"Norm" wrote in message
...
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!!!

Roger Govier[_8_]

Calculation help

Hi Norm

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

Norm wrote:
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!!!

All times are GMT +1. The time now is 02:11 PM.