View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ClarkeTeam ClarkeTeam is offline
external usenet poster
 
Posts: 3
Default Calculating productivity: widgets per hour

My spreadsheet contains a row of hours worked by our team per day -- 31:06,
18:32, 43:44. I also have a column of number of widgets produced that day.

How can I get Excel to calculate the number of widgets produced per hour?
For example, row A is 7/1/07 and we had 40:00 labor hours that day (A2) and
60 widgets produced that day (A3). I need a calculation that says =A3/A2 and
the result is 1.5 widgets per hour.