N
Norbert
For every day I keep records of machine down-time for 20 machines
on worksheet: "downtime history"
A B C
D
date mach.no. down-time day-shift down-time night-shift
07-10-08 12 03:00 06:00
07-10-08 13 00:00 01:10
07-10-08 14 02:20 00:10
and so on.....
On my analysis sheet "efficiencies" I can change the date in cell: B3
in L3:L26 I have the machine numbers. In M3:M26 I need the downtime
for each machine for the date in B3.
Is that possible to lookup in the database I keep on sheet: "downtime
history"?
To be answered:
What was the <downtime day-shift> for machine 12 on the date in B3?
I basically have to lookup 2 values; the date and the machine and that
is where my problem is.
Thanks.
on worksheet: "downtime history"
A B C
D
date mach.no. down-time day-shift down-time night-shift
07-10-08 12 03:00 06:00
07-10-08 13 00:00 01:10
07-10-08 14 02:20 00:10
and so on.....
On my analysis sheet "efficiencies" I can change the date in cell: B3
in L3:L26 I have the machine numbers. In M3:M26 I need the downtime
for each machine for the date in B3.
Is that possible to lookup in the database I keep on sheet: "downtime
history"?
To be answered:
What was the <downtime day-shift> for machine 12 on the date in B3?
I basically have to lookup 2 values; the date and the machine and that
is where my problem is.
Thanks.