I've tryied to in modify the formula for night shift but it does not work
=INDEX(MOD(dataexport!$I$2:$I$20;1);MATCH(1;(dataexport!$G$2:$G$20=$A3)*(INT(dataexport!$I$2:$I$20)=($B$1:$E$1));0))
B1 has the today date 24/07/2011 and E1 tomorrow date 25/07/2011 by having the extra date I can manage the night shifts.
For OUT time I need the formula to compare the date from today and the date from tomorrow with the date from data export
Bookmarks