View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
 
Posts: 863
Default 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