K
KBJ
Hi
I've got a manual machine at work that produce about 500 row's a day
6 day's a week
It produce a table like this.
Count Instr Scale Batch Gross Date Time
5000 1 1 8500 2,2 2007-04-20 11:00:10
5001 1 1 8501 2,3 2007-04-20 11:00:50
5002 1 1 8502 2,2 2007-04-20 11:06:12
And so on
What I like to do is to determine if the time between the row's >= 3
minutes, if it is, it's stop time
and of course then summarize the stop time between two date's
I've got a manual machine at work that produce about 500 row's a day
6 day's a week
It produce a table like this.
Count Instr Scale Batch Gross Date Time
5000 1 1 8500 2,2 2007-04-20 11:00:10
5001 1 1 8501 2,3 2007-04-20 11:00:50
5002 1 1 8502 2,2 2007-04-20 11:06:12
And so on
What I like to do is to determine if the time between the row's >= 3
minutes, if it is, it's stop time
and of course then summarize the stop time between two date's