Couple of problems
This part
AND(WEEKDAY(C2,2)5,IF(WEEKDAY(C2,2)<6
can never be true,
and what is TM
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Baapi" wrote in
message ...
Hello there,
Can Some One please Help in Converting the following Formula to a
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)<T
ime!$A$21),Time!$A$21,TM(C2)),IF(WEEKDAY(C2,2)<7,I F(TM(C2)=Time!$A$5,Time!$
A$21,TM(C2)),Time!$A$21))=Time!$A$21),INT(C2+2),IN T(C2))
Thanks,
Baapi
--
Baapi
------------------------------------------------------------------------
Baapi's Profile:
http://www.excelforum.com/member.php...o&userid=27333
View this thread: http://www.excelforum.com/showthread...hreadid=477930