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