LinkBack URL
About LinkBacks
This seems to work:Formula:
=IF(C$2<$B3, 1440*MIN(MAX(, C$2+1/24-$A3+($A3>$B3)), MAX(, MOD($B3-C$2, 1)), MAX(, MOD($B3-$A3, 1)), 1/24), IF(AND($A3>$B3,SUM(C$2,1/24)>$A3),1440*MIN(1/24,SUM(C$2,1/24)-$A3),""))
Let us know if you have any questions.
This seems to work:Formula:=IF(C$2<$B3, 1440*MIN(MAX(, C$2+1/24-$A3+($A3>$B3)), MAX(, MOD($B3-C$2, 1)), MAX(, MOD($B3-$A3, 1)), 1/24), IF(AND($A3>$B3,SUM(C$2,1/24)>$A3),1440*MIN(1/24,SUM(C$2,1/24)-$A3),""))
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
This worked!!! Thank you!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks