LinkBack URL
About LinkBacks
maybe a variation on daddylonglegs' formula
=MAX(0,B3-MAX(A3,INT(A3)+"20:00"))+MAX(0,MIN(B3,INT(B3)+"6:00")-A3)*(HOUR(A3)<6)
maybe a variation on daddylonglegs' formula
=MAX(0,B3-MAX(A3,INT(A3)+"20:00"))+MAX(0,MIN(B3,INT(B3)+"6:00")-A3)*(HOUR(A3)<6)
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks