View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sambusa[_15_] Sambusa[_15_] is offline
external usenet poster
 
Posts: 1
Default Calculating the difference between hours


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 !!!
SAM

--
Sambus
-----------------------------------------------------------------------
Sambusa's Profile: http://www.excelforum.com/member.php...fo&userid=1496
View this thread: http://www.excelforum.com/showthread.php?threadid=26588