parts per hour

[Oneblondeboy]

Ok simple one here I hope, I need to calculate the parts per hour, I have the run time in the form of 1:30 then the parts is 75 so my answer should be 50 parts per hour. I get my runtime from the current time of day then I enter the start time as 4:00 pm to get the 1:30 it may a formatting issue too not sure thanks for you help in advance.

 

[shg]

Multiply 1:30 by 24 to convert elapsed time to decimal hours (1.5). So =parts / (time * 24)