Dear Sir,
I need to extract data from my automatic location-wise data entry sheet, in this sheet thousand of rows with two times one is the Occurring and one is the Clearing time.
but from some days datasheet received with fake entries and hard to find fake entries because of a lot of entries.
Below mention one location entry example;
Occurring on 9/16/2021 12:00:00 AM
Cleared on 9/16/2021 8:37:26 AM
But the Next entry again comes from12am to 8 am.
first three rows are genuine others are fake
I need to extract data from my automatic location-wise data entry sheet, in this sheet thousand of rows with two times one is the Occurring and one is the Clearing time.
but from some days datasheet received with fake entries and hard to find fake entries because of a lot of entries.
Below mention one location entry example;
Occurring on 9/16/2021 12:00:00 AM
Cleared on 9/16/2021 8:37:26 AM
But the Next entry again comes from12am to 8 am.
first three rows are genuine others are fake
| Location | Occurring | Clearing |
| CMN0609__S_warid_MDCM6039 | 2021-09-16 00:00:00 | 2021-09-16 08:37:26 |
| CMN0609__S_warid_MDCM6039 | 2021-09-16 00:00:00 | 2021-09-16 08:37:25 |
| CMN0609__S_warid_MDCM6039 | 2021-09-16 00:00:00 | 2021-09-16 08:37:24 |
| CMN0609__S_warid_MDCM6039 | 2021-09-16 00:00:00 | 2021-09-16 06:18:30 |
| CMN0609__S_warid_MDCM6039 | 2021-09-16 00:00:00 | 2021-09-16 06:15:56 |
| CMN0609__S_warid_MDCM6039 | 2021-09-16 00:00:00 | 2021-09-16 06:15:53 |
| CMN0609__S_warid_MDCM6039 | 2021-09-16 00:00:00 | 2021-09-16 06:15:52 |
| CMN0609__S_warid_MDCM6039 | 2021-09-16 00:00:00 | 2021-09-16 06:15:51 |
| CMN0609__S_warid_MDCM6039 | 2021-09-16 00:00:00 | 2021-09-16 06:15:50 |
| CMN0609__S_warid_MDCM6039 | 2021-09-16 00:00:00 | 2021-09-16 06:15:49 |
