LinkBack URL
About LinkBacks
sulbaran 
Based on your sample, try this, copied down. It picks up only those 2 that you highlighted...
=AND((B2*1)<=INT(B2*1)+19/24,(C2*1)>=INT(B2*1)+19/24)
Based on your sample, try this, copied down. It picks up only those 2 that you highlighted...
=AND((B2*1)<=INT(B2*1)+19/24,(C2*1)>=INT(B2*1)+19/24)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks