LinkBack URL
About LinkBacks
Try this - I haven't fully tested it.
=IF(AND(OR(WEEKDAY(A2)={4,6}),HOUR(A2)<16),INT(A2),INT(A2)-CHOOSE(WEEKDAY(A2),1,2,3,4,1,2,3))+16/24
Try this - I haven't fully tested it.
=IF(AND(OR(WEEKDAY(A2)={4,6}),HOUR(A2)<16),INT(A2),INT(A2)-CHOOSE(WEEKDAY(A2),1,2,3,4,1,2,3))+16/24
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks