Re: Elapsed Time
- From: "Tom Ellison" <tellison@xxxxxxxxxxx>
- Date: Wed, 22 Mar 2006 16:46:21 -0600
Dear John:
Why not? If your sample is the case (and I do not know that it is), then
you would know the machine was down for 70 minutes a total of 3 times out of
28 days (all of February, if that is the case).
(28 * 24 * 60 - 70) / 3
(days * hour per day * minutes per hour - down time) / number of failures
Seems sufficient to me! What am I missing?
Tom Ellison
"John Vinson" <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1ck322963dupbgo0vl54i9uhqo0c0b1q6t@xxxxxxxxxx
On Wed, 22 Mar 2006 12:38:27 -0800, Pickled Princess <Pickled
Princess@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
We are tracking downtime on our production equipment in an Access
database.
The reports that are keyed into the database list the date of the
downtime,
the equipment that was down and the length of time of each instance. We
run a
query to isolate a certain piece of equipment with it's downtime but then
would like for Access to be able to calculate the average elapsed time
between failures. Any suggestions would be greatly be appreciated by this
wet
behind the ears Access user.
Ok, let's see if I understand.
On February 21 machine XYZ was down for 10 minutes.
On February 21 it was down again for 15.
On February 24 it was down for 45.
What's the time between failures?
You don't appear to have any information in your table which would
allow Access (or anything else) to answer the question, or perhaps I
don't understand the question.
John W. Vinson[MVP]
.
- References:
- Re: Elapsed Time
- From: John Vinson
- Re: Elapsed Time
- Prev by Date: Re: OLAP CUBE ERROR
- Next by Date: Re: Help! Trying to set a maximum value on a query result.
- Previous by thread: Re: Elapsed Time
- Next by thread: Done with one query?
- Index(es):
Relevant Pages
|
