Calculating the difference between hours
You only need to add 2 when you use the dates as arguments in NETWORKDAYS
function. I don't see that function in the part of the formula you show.
On Wed, 6 Oct 2004 11:41:40 -0500, Sambusa
wrote:
Pls u mean i have to write like this
=IF(AND(INT(C2+2)=INT(L2+2),NOT(ISNA(MATC2+2H(INT (C2+2),C9:C10,0))))
,0,ABS(IF(INT(C2+2)=INT(L2+2),ROUND(24*(L2+2-C2+2),2),.....
WAITING !!!
SAMI
|