Identifying duplicate time frames

There appears to be something wrong with your example picture. In row 4, the IN date and time is LATER than the OUT date and time.

Attach a sample workbook instead of a picture. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

thanks newdoverman, example worksheet attached.

the previous picture is correct however. the sheet is the combination of data from several collection points that all work offline, hence the ability, if somebody is abusing the system, to clock in in several places at once - the hoped for formula is to help identify this in sheets of thousands of entries without having to manually sort through each person.

many thanks again

You may try this to see if you get the desired output....

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

Another way ... by formula. With a helper column in column I. If I understand the problem correctly this formula in the helper column should do it.

Formula:

Please Login or Register  to view this content.

I've also applied it to the Before sheet to verify that it works there, too.

With the Applies to: in Format Manager set to A2:H5 and using formula to set criteria with this formula: =$I2>1

set your background color and apply.

Workbook is attached.

Dim t ?

What was that supposed to be? I didn't see you used the variable "t" in your code.

Did I miss something?

Thanks Marvin, You have pointed this out correctly.
That variable is not used at all. I declared it in the beginning and thought I would use it later but didn't use it.

You're welcome.

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.