Determine difference in time

Hello,
I’m using VBA to run a code for an excel spreadsheet. My spreadsheet has four columns (DATE, TIME, USER, ACTION) and about 400 rows.

I’d like my code to determine if there was less than 4 minutes between actions for a user. If it determines that this is true, then all of the text in the “older time” in those 4 columns making up that row should change to red.

EXAMPLE:
(1) 9/30/14 21:56 32 IN
(2) 9/29/14 20:45 28 IN
(3) 9/29/14 20:44 28 IN
(4) 9/28/14 19:12 31 IN
(5) 9/28/14 19:10 27 IN
(6) 9/27/14 12:36 28 IN
(7) 9/26/14 12:34 28 IN

-Row 3 should change to red text in that row because the time difference is less than 4 minutes and it is the same user (#28) and it is the ‘older’ time

-Row 5 does not change to red text – even though the time difference is less than 4 minutes, they are not the same user

-Row 7 does not change to red text – even though the time difference is less than 4 minutes, and it is the same user, the action occurred on a different day

Any help and shared expertise would be greatly appreciated! Thank you!

Hi lacke81c and welcome to ExcelForum,

When I tested the following macro, the data started in cell "A1" (date).

Please Login or Register  to view this content.

Lewis

Thank you LJMetzger !

It is working perfectly