Thread
:
formula to calculate time values
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
formula to calculate time values
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
with @tiscali.co.uk
"kjp" wrote in message
...
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann