Time

[Doug]

I am looking to time different things that employees do
at our work place to come up with an average time. The
problem is that everything is done as a time function as
in 1m:11s is really 12:01:11 AM in the formula bar. I
just want it to be minutes and seconds so that when i
figure it takes 10m:45s on average to do a task i can
figure out how many of those tacks i can do in an hour on
average.i.e. 60/10m:45s=circular referance. It should be
5.2 10:45s duties in one hour. How do i do it like that
or can i??????

[Jerry W. Lewis]

[J.E. McGimpsey]

To XL, times of day (12:01:11 AM) and elapsed times (1:11) are the
same value - just displayed differently. XL stores both times of day
and elapsed times as fractional days, so 3:00 AM or 3:00 = 0.125. You
can format elapsed times using Format/Cells/Number/Time and choosing
the appropriate format (e.g., "13:30:55").

Since times are numbers to XL, you can average them using
=AVERAGE(A1:A10), say.

To find out how many tasks per hour, for example:

A1:A10 time data
A11: =AVERAGE(A1:A10) ===> 0:10:45
A12: =TIME(1,0,0)/A11 ===> 5.6

will give you the number without a circular reference.

In article <335d01c2f109$6dbda520$3301...@phx.gbl>, Doug

[Jerry W. Lewis]

Time is stored as a fraction of a day. If you format 12:01:11 AM with
General format, you will get 0.000821759 which is =((1+11/60)/60)/24.
If you multiply by 24 (hours) then you will get the fraction of an hour.
If you further multiply by 60 (minutes) then you will get the fraction
of a minute, which you can use in your desired formula.

"Circular reference" is a separate issue. That says that you are tring
to use the same cell as both input and output. You can't do that, and
you have not given enough information to specifically diagnose the
problem. Look at Help on "Circular reference"

Jerry