Finding row on matrix matching 3 criteria and get a result (hour)

MoonAlert

New member
Joined
Dec 11, 2012
Messages
1
Reaction score
0
Points
0
Hello,

The matrix:
Col A Col B Col C
2012-11-08 07:26:16 Check-In John
2012-11-08 13:23:58 Check-Out John
2012-11-08 13:24:01 Check-In John
2012-09-27 07:34:13 Check-In Marie
2012-09-27 17:35:31 Check-Out Marie
2012-09-28 07:10:16 Check-In Marie
2012-09-28 17:34:40 Check-Out Marie

The goal:
Since i have a given:
1. Name(which exists in column C)
2. Date (which exists in column A - formated has (AAAA-MM-SS HH:MM:SS)
3. Event (which exists in column B)
4. Hour*

I want to know the nearest hour that matches all criterias.

In the example on top, if i give:
John, 2012-11-08, Check-In, 14:00:00
I want the result: 13:24:01

If, for example, the date doesn't exist, the result could be a simple error message.

Anyone can help me?

Thanks in advance!
 
Top