Separating Date & Time for Function

I have a report which combines the date with a time. I actually need to organize and work with the data associated with these combined fields based upon the time. I need to create some functions whic...

excel

Formulas and Functions

Abiola1
Jan 09, 2020
Hello, dsmith5740

In addition, you can use Power Query to Separate the Date & Time
Click anywhere in the data and execute CTRL + T
Check my table has headers and click OK
In the Get & Transform, click on From Table
In the Power Query editor, click on Split Column in the Home tab
Select By Delimiter
Select Space from the drop-down
Check Left-most delimiter
Click OK. From the caption below, we have the date and time splited into two columns

Then, you can choose Close & Load to load the result back to excel