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

Side not: Forgot to mention that I will be adding a cell to ehtner the
time. Is there a formula that will convert the hrs/minutes to minutes so
the result can be used in a formula?
"kjp" wrote in message
...
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