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

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

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


"kjp" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>
>

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


"kjp" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>
>