formula to calculate time values

  • Thread starter Thread starter kjp
  • Start date Start date
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
 
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?
 
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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace formula with calculated value 1
Logical value in time formula? 4
Display Last Value Calculated in Formula Range 1
Creating a Formula to Calculate Time Value in an Option 1
Simple calculation where values change to letters? 3
formula to find a range of cells = to a value 4
Alternative formula to exclude holiday calculation 6
I need a formula to do some calculations with time. 4

Back
Top