I want to match two spread sheet with time

Converting the time in to Number format and rounding it is the only way ..

Find enclosed Worksheet as example .. Hope its fine ?
Fredy

Thanks for the reply, but most of the times, there will not be exact match for the time, so we need to find the approximate time not the exact match.

I am looking for a solution where the data match the customer id first and them approximate match with the time.

Please help

Dear Kevin,

I want to match two item from the excel 1 and excel 2 and extract the corresponding voucher values to excel 2 from excel 1. First I want match the codes then corresponding to code i want to match the time and extract the voucher value.

Alternatively we can match both the code and time together ( it is to be noted that time will be diffrent most of the case so we need to match it approximate) I am attaching the excel once again for your help.

Excel 1

Voucher Time Code
4399122776 10:36:28 S0584390
7453377203 10:58:02 S0595579
2700228119 11:03:14 S0584390
2539425656 11:11:28 S0595579
9268523233 11:25:42 S0595579
9574583310 11:33:45 S0584388
7822085869 11:45:16 S0595573
6239409232 11:46:41 S0595580
2794907139 12:05:43 S0584389
8955253849 12:31:21 S0595579
7668032277 12:49:07 S0584388
6284678781 12:49:51 S0584390
6777059729 12:52:26 S0584384
1826650049 13:12:24 S0584392
6973660744 13:28:11 S0584388
7564362019 13:45:06 S0595573

Excel 2

Date Time Code Voucher
4/1/2013 0:00 2:03:28 S0584392 ?
4/1/2013 0:00 2:27:40 S0584388 ?
4/1/2013 0:00 2:35:56 S0584388 ?
4/1/2013 0:00 2:55:03 S0595570 ?
4/1/2013 0:00 3:05:09 S0584390 ?
4/1/2013 0:00 3:21:49 S0584390 ?
4/1/2013 0:00 3:26:14 S0584388 ?
4/1/2013 0:00 3:58:05 S0595576
4/1/2013 0:00 4:15:50 S0584388
4/1/2013 0:00 4:28:10 S0584392
4/1/2013 0:00 4:46:00 S0595576
4/1/2013 0:00 4:55:09 S0584389
4/1/2013 0:00 5:07:52 S0595579
4/1/2013 0:00 5:12:05 S0584388
4/1/2013 0:00 5:23:05 S0595579
4/1/2013 0:00 5:35:12 S0584392
4/1/2013 0:00 6:09:18 S0584388
4/1/2013 0:00 6:41:45 S0584388
4/1/2013 0:00 6:48:09 S0584388
4/1/2013 0:00 6:50:43 S0584389
4/1/2013 0:00 7:00:41 S0584386
4/1/2013 0:00 7:08:45 S0584389
4/1/2013 0:00 7:11:30 S0584389
4/1/2013 0:00 7:14:29 S0584388

Regards
Sreejan

You cannot get exact time .. cos its infinite .. u understood .. its not a constant value .. Will differ for .. So u got to round it up to get a constant value..

Dear Quang,

Thanks for your reply, but with the same code its does not mean that we will have same voucher number. The voucher will be different with code and time. Can we do a exact match criteria for code and approximate match for time and extract the corresponding voucher.

Regards
Sreejan

can we convert time to a decimal and add the code with the converted decimal(we can do it in excel 1 & excel 2) and can we find the approximate match, if yes can help me to get formula