A ashish mehra Active Member May 4, 2016 #1 Hi all, Pl check attached file; require answer is mentioned. Regards Attachments Shift timings by each Country.xlsx 9.6 KB · Views: 25
Ashhu Active Member May 5, 2016 #2 Ashish Please check attached sheet. Attachments Shift timings by each Country (4).xlsx 10.4 KB · Views: 8
B bosco_yip Excel Ninja May 5, 2016 #3 Just modified Ashhu's formula, In D2, copy down : =IF((MOD(C2,1)-VLOOKUP(A2,J$1:K$2,2,0))*1440<120,"Pass","Fail") Regards Bosco
Just modified Ashhu's formula, In D2, copy down : =IF((MOD(C2,1)-VLOOKUP(A2,J$1:K$2,2,0))*1440<120,"Pass","Fail") Regards Bosco
