formula to calculate time values

K

kjp

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
 
K

kjp

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?
 
S

Sandy Mann

KJ,

Assumong that the 9 hr 13 minutes in entered as an XL time like 9:13, then
with the number handled in A1 and the time taken in B1 use:

=A1/(B1*24)

I am afraid that I don't really understand your second question.

--
HTH

Sandy
In Perth, the ancient capital of Scotland

[email protected]
[email protected] with @tiscali.co.uk
 
Top