View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kjp kjp is offline
external usenet poster
 
Posts: 2
Default formula to calculate time values

Is there a way to write a formula into a cell that will calculate a standard
numerical value divided by a time value?

Ex: A worker handled 26976 pcs in 9 hrs 13 minutes. How would I write a
calculation that would calculate and display how many pieces were handled
per hour?

--
--
K.J. Pierce
Maverick Media, Inc.
Liberty Group Nebraska Holdings, Inc.
P.O. Box O
Syracuse, NE 68446
402.269.2135 ext 236
(fax) 402.269.2392