Grizlore
Active Member
- Joined
- Aug 22, 2006
- Messages
- 259
I have a lots of cells which contain date and times (eg 11/11/2010 14:39) these refer to a production date on a particular shift.
The shift pattern are quite complicated and illogical to calculate, however the each shift starts at either 07:00, 15:00 or 23:00
Therefore, I was thinking the easiest way to lookup which shift this date and time refers, is to do a do a formula to see which shift the time falls into.
Then. once I know which shift, I can do a vlookup which looks at a table with four columns
Date – 0700 – 1500 – 2300
Which shift is working when can be added into this table.
The vlookup will look at column 2 if a morning shift (0700), column 3 if afternoons (1500)etc…
I guess this the best way to go about this?
Question.... Which formula function would be best to look at the date and time, 11/11/2010 14:39, and calculate which of the three shift the time falls?
thanks for your time
Any help and pointer would be much appreciated
The shift pattern are quite complicated and illogical to calculate, however the each shift starts at either 07:00, 15:00 or 23:00
Therefore, I was thinking the easiest way to lookup which shift this date and time refers, is to do a do a formula to see which shift the time falls into.
Then. once I know which shift, I can do a vlookup which looks at a table with four columns
Date – 0700 – 1500 – 2300
Which shift is working when can be added into this table.
The vlookup will look at column 2 if a morning shift (0700), column 3 if afternoons (1500)etc…
I guess this the best way to go about this?
Question.... Which formula function would be best to look at the date and time, 11/11/2010 14:39, and calculate which of the three shift the time falls?
thanks for your time
Any help and pointer would be much appreciated