First of all i would like to thank all of u & i appreciate ur help
I would like to explains some thing & ask about some thing

1\ The formula which i mentioned above workinf 90% ,
What i would like to ask about is EXCEL asume the holiday is Sat & Su
but i wan it to take Thu & Fri as a holiday

How can i do that pls ?

2\ the result of the formula is number ( 1.50 ) which is mean 1:30 ...
How can i change it to display 1:30 not 1.50


Waiting for ur reply now!!

Thanks for all
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