Filter Based on Time Criteria and Copy to New Sheet

[Barieq]

Hi,

Can anyone help me to Filter time based on Clock In and Clock Out criteria and copy the filtered data to a new sheet.

First, if Clock In is Blank and time is > 08:15

Second, if Clock out is Blank & time is < 17:15

I have attached the Sample Worksheet.

Regards

[AlphaFrog]

Do you mean...

First, if Clock In is Blank and Clock Out time is > 08:15

Second, if Clock out is Blank & Clock In time is < 17:15

If yes, your example doesn't have any rows where Clock In is Blank and Clock Out is not blank.

[Barieq]

Yes, Column E (Clock In) where it is Empty and Time is > 08:15 and Column F (Clock Out) where it is Empty and Time is < 17:15

[Barieq]

Hi

Is there a solution for this thread?

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[AlphaFrog]

This copies the filtered data to sheets Sheet2 and Sheet3.

Please Login or Register  to view this content.

[Barieq]

Dear John & Alpha

Thanks for the code, but it is not giving the expected result when I run the macro. I have attached the worksheet with expected results in Sheets ("After").

[JOHN H. DAVIS]

Lines 14, 15 and 16 on your After sheet do not meet the logic you requested? What's the rule for those?

Maybe:

Please Login or Register  to view this content.

[Barieq]

Lines 14, 15 and 16 on your After sheet do not meet the logic you requested? What's the rule for those?

Maybe:

Please Login or Register  to view this content.

I will go through it on Saturday, at present I am out of office

[jindon]

Sucuri doesn't accept the code to upload here, so try the attached.

[Barieq]

Thanks Jindon, Sorry due to weekend here I could not reply. Perfect result as expected. Special thanks to John and Alpha, I will mark this thread solved.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.