Command buttons for filtering

[marc5354]

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

[martindwilson]

=IF(OR(D7="",D7="Pending",D7="Cancelled"),"",(D7-C7)*OR(F7="",F7="Pending",F7="Cancelled")-(F7-E7))
what is this supposed to do/show?

[marc5354]

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

[marc5354]

=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

[martindwilson]

=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))

[marc5354]

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

[martindwilson]

all yours pike!

[marc5354]

*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.

[marc5354]

i don't know how get the time difference between D-C and L-F.

[marc5354]

Sir

Can you please help me out.., how to get time difference between D7-C7 or F7-E7.

Thank you
...Marc

[martindwilson]

TRY
=IF(OR(F7="",F7="Pending",F7="Cancelled"),IF(OR(D7="",D7="Pending",D7="Cancelled"),"",(D7-C7)),F7-E7)

[marc5354]

Sir,

Can you please see the file, which i attached. still having some problems

...Marc

[martindwilson]

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 #############

[marc5354]

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

[martindwilson]

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

[marc5354]

thank you for your help and time

Any hope...

[marc5354]

please help me