Hello there,

Can Some One please Help in Converting the following Formula to
Function?

C2 Contains "dd-mmm-yyyy hh:mm:ss"
Time A5 Contains 02:30:00
Time A21 Contains 17:30:00

=IF(AND(WEEKDAY(C2,2)5,IF(WEEKDAY(C2,2)<6,IF(AND( TM(C2)=Time!$A$5,TM(C2)<Time!$A$21),Time!$A$21,TM (C2)),IF(WEEKDAY(C2,2)<7,IF(TM(C2)=Time!$A$5,Time !$A$21,TM(C2)),Time!$A$21))=Time!$A$21),INT(C2+2), INT(C2))

Thanks,
Baap

--
Baap
-----------------------------------------------------------------------
Baapi's Profile: http://www.excelforum.com/member.php...fo&userid=2733
View this thread: http://www.excelforum.com/showthread.php?threadid=47793