Time Conversion Issue

Frost2FA 

Hi

This issue can be fixed in one of 2 ways without the need of formulas and functions

Method 1:

Power Query

1. Convert the column showing date and time  (or even the entire list) into Table (CTRL +T)
2. Click on the Data Tab >> From Table >> Most probably there will be an automatic change in Data Type to the correct Date. If Not
3. Select the Date column to Fix >> Click on Add Column 
4. To the Right side >> Click on Date >> Date Only
5. Or Click on Time >> Time Only
6. Remove unwanted columns (right Click >.remove)
7. Click on the Home Tab >> Close and load >. Data Fixed an sent back to Excel

Method 2:

Text To Column

1. select the Column to Fix
2. Data Tab >> Text To Column
3. Step 1 of the Wizard >> Select Delimiter
4. Step 2 >> Select Space
5. Step 3 >> Select MDY (for Date)
6. Select Destination to paste Fixed Data

Hope that helps

Nabil Mourad