Calculating time and sale value

[ianlj]

I am trying to calculate the potential sale value of a product, based on the time it takes to make it over an hour.


[TABLE="width: 500"]
<tbody>[TR]
[TD]Unit[/TD]
[TD]Calculation[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]Sale price per widget[/TD]
[TD][/TD]
[TD]$5.00[/TD]
[/TR]
[TR]
[TD]Production time per widget (mm:ss)[/TD]
[TD][/TD]
[TD]2:10[/TD]
[/TR]
[TR]
[TD]Production volume per hour (60 minutes/ Production time per widget)[/TD]
[TD]60/ 2:10[/TD]
[TD]28.57[/TD]
[/TR]
[TR]
[TD]Potential sale (Production volume per hour * Sale price per widget)[/TD]
[TD](28.57 X $5:00)[/TD]
[TD]$142[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Can any show me how to automate the time calculation of the Production volume per hour (60 minutes/ Production time per widget).



Thanks

 

[Eric W]

Assuming you have the production time in C3, and it's formatted as a time (I used 12:34:56 time formatting), the formula in C4 could be:
=60/(MINUTE(C3)+SECOND(C3)/60)

Then you'll need to change the format in C4 to a number format, since Excel will pull the time format over.