You are my last chance to find a solution : I have 2 cells (C6 & D6 ; 08:00:00 & 12:26:00) and a simple formula ( =D6-C6 ). This one is working properly but I have another one ( =IF(OR(C6="JF";C6="WE");"00:00";D6-C6) ) wich is quit simple but as you can see on this photo :
The result of this second formula is quit not the same as the first one...which is weird as they have the same end ( D6-C6 )...I need either an explaination of why and a solution tu have the 4:26 end on the second formula.
I've tried this one : ( =SI(OU(C6<>"JF";C6<>"WE");D6-C6;"00:00:00") ) but the result is the same ( 0,184722222 ).
Aucun commentaire:
Enregistrer un commentaire