ExcelMentee
Banned - Rules violations
- Joined
- Jan 11, 2021
- Messages
- 31
- Office Version
- 365
- Platform
- Windows
when i download the data from software it comes in that shape.
Untitled Spreadsheet
I want to convert this data into present able format that is
First It will get the date in the format that i have use but i paste these dates manually because TEXT function is not working for this
Secondly Its name and ID's will paste accordingly.
Third one is the main formula or function that to separate the Start date and the Stop Date from the "Date In and Out" Column.
your help will be highly appreciated.
Untitled Spreadsheet
Date In and Out | ID | Name |
13.01.2021 15:05 | 0000120066DF | Stefan Hellemans |
13.01.2021 11:56 | 0000149E0240 | Lutgard Heremans |
13.01.2021 08:20 | 0000149E0240 | Lutgard Heremans |
13.01.2021 06:56 | 0000120066DF | Stefan Hellemans |
12.01.2021 15:02 | 0000120066DF | Stefan Hellemans |
12.01.2021 07:01 | 0000120066DF | Stefan Hellemans |
11.01.2021 15:34 | 0000149E0240 | Lutgard Heremans |
11.01.2021 14:59 | 0000120066DF | Stefan Hellemans |
11.01.2021 08:24 | 0000149E0240 | Lutgard Heremans |
11.01.2021 06:51 | 000011FE671A | Stefan Hellemans |
07.01.2021 09:33 | 000011FE671A | Stefan Hellemans |
06.01.2021 13:26 | 000011FE671A | Stefan Hellemans |
I want to convert this data into present able format that is
Data | ID | Name | Start | Stop |
1/7/2021 | 000011FE671A | Stefan Hellemans | 07.01.2021 09:33 | |
1/11/2021 | 000011FE671A | Stefan Hellemans | 11.01.2021 06:51 | 11.01.2021 14:59 |
1/11/2021 | 0000149E0240 | Lutgard Heremans | 11.01.2021 08:24 | 11.01.2021 15:34 |
1/12/2021 | 000011FE671A | Stefan Hellemans | 12.01.2021 07:01 | 12.01.2021 15:02 |
1/13/2021 | 000011FE671A | Stefan Hellemans | 13.01.2021 06:56 | 13.01.2021 15:05 |
1/13/2021 | 0000149E0240 | Lutgard Heremans | 13.01.2021 08:20 | 13.01.2021 11:56 |
First It will get the date in the format that i have use but i paste these dates manually because TEXT function is not working for this
Secondly Its name and ID's will paste accordingly.
Third one is the main formula or function that to separate the Start date and the Stop Date from the "Date In and Out" Column.
your help will be highly appreciated.