Hello everyone...
I am looking for command buttons for filters and IF And OR formulas for find out the turn around time. Some functions are working properly and some aren't. Please help me regarding this issue. Here attached file for your reference.
Thank you
...Marc
=IF(OR(D7="",D7="Pending",D7="Cancelled"),"",(D7-C7)*OR(F7="",F7="Pending",F7="Cancelled")-(F7-E7))
what is this supposed to do/show?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hello Guru,
Thank you for your time and help..
Please find attached file for with Query details. This is what i want i explained hope this will help us.
Thank you very much Guru
...Marc
=IF(OR(D7="",D7="Pending",D7="Cancelled"),"",(D7-C7)), its shows time difference between file completed time and file received time.
Thank you for your time
...Marc
=IF(OR(D7="",D7="Pending",D7="Cancelled"),"",(D7-C7)) is fine but i dont see what the second part is trying to do
*OR(F7="",F7="Pending",F7="Cancelled")-(F7-E7))
Sir Mr. Pike also working on this query in another post.. i was wrongly posted twicely. In new post i added some new functions.
Please forgive me, for my mistake...
Thank you for your time and patience
...Marc
all yours pike!
*OR(F7="",F7="Pending",F7="Cancelled")-(F7-E7)), Yes sir this part doesn't working.. Even i don't know. Are there any possibilities to run both the formulas same time.
i don't know how get the time difference between D-C and L-F.
Sir
Can you please help me out.., how to get time difference between D7-C7 or F7-E7.
Thank you
...Marc
TRY
=IF(OR(F7="",F7="Pending",F7="Cancelled"),IF(OR(D7="",D7="Pending",D7="Cancelled"),"",(D7-C7)),F7-E7)
Sir,
Can you please see the file, which i attached. still having some problems
...Marc
02/04/2010 08:00:00 PM 02/04/2010 09:10:00 AM
the second time is earlier than the first you cant have -ve times thats why you are getting #############
Yes sir you are correct, Thank you
In E8 & F8 both are blank, so i want K8 also blank. if search on hold and search received thn only search period will show the search hours in K8.
...Marc
this is looking to go on a long time! thats not what you asked for you said if e8 and f8 are blank then use the values in d8 and c8 which is what that formula does
thank you for your help and time
Any hope...
please help me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks