C
claude jerry
I Have Data as Follows
A B C D E
Time 1st 2nd 3rd 4th
7:00 0 1
7:10 0 0
7:20 1 2
7:30 4 1
7:40 3 3
7:50 8 9
8:00 10 11
8:10 8 5
8:20 15 11
Etc
7:00, 7:10, 7:20 etc are clock time and 0 , 1 , 4 etc are No of Employees
who ented the gate.
I want to find out the 3 Clock time for each day where min Employees has
entered the gate for each day. want to Insert a Formula Below each Column.
Eg Sol. for Data Above (3 Least busy time Slots)
A B C
7:00 7:10
7:10 7:00
7:20 7:30
Basically I want to Know for each day, 3 Slots of time where entry in minimum.
Thanks
A B C D E
Time 1st 2nd 3rd 4th
7:00 0 1
7:10 0 0
7:20 1 2
7:30 4 1
7:40 3 3
7:50 8 9
8:00 10 11
8:10 8 5
8:20 15 11
Etc
7:00, 7:10, 7:20 etc are clock time and 0 , 1 , 4 etc are No of Employees
who ented the gate.
I want to find out the 3 Clock time for each day where min Employees has
entered the gate for each day. want to Insert a Formula Below each Column.
Eg Sol. for Data Above (3 Least busy time Slots)
A B C
7:00 7:10
7:10 7:00
7:20 7:30
Basically I want to Know for each day, 3 Slots of time where entry in minimum.
Thanks