Excel time comparison -
i have given workers' start/end(coming work , going out work times) time in excel table. in 2nd table, have given breakfast, lunch, dinner start/end times. how can check worker can eat breakfast, lunch, dinner?
you write in columns d, e, f (to check breakfast, lunch, dinner, respectively):
d2
: =if(and($h$2>b2,$i$2<c2),"yes","no")
e2
: =if(and($h$3>b2,$i$3<c2),"yes","no")
f2
: =if(and($h$4>b2,$i$4<c2),"yes","no")
then copy d2:f2
, paste below.
Comments
Post a Comment