LinkBack URL
About LinkBacks
Nobody ?????(((((
Nobody ?????
Hi try this
Or this
=IF(COUNT($C6,$E6)=2,MAX(0,MIN($E6+($C6>$E6))-MAX($C6)),0)
place in F6=MOD(E6-IF(C6 < TIME(22,0,0),TIME(22,0,0),C6),1)
Last edited by Toonies; 01-06-2012 at 05:45 PM.
Thanks Toonies but it's not working.
I see the point of your formula.
H6 has to calculate time if in C6 is more than 22:00 and in E6 is less than 05:00 trough the midnight.
I will keep trying, but thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks