2 Methods to Separate DATE and TIME in Excel

In this video, I demonstrate two dynamic methods for separating date and time in Excel. Learn how to use the Integer (INT) function and Power Query to split date/time values efficiently. This method is perfect for analyzing data trends like popular class times or times that are popular for customers who purchase from us! In this video, I show you how to use the Integer function to extract date and time separately, create a PivotTable to analyze popular class times, utilize Power Query for a more dynamic approach, and refresh data automatically with Power Query.

Chapters:
0:00 Introduction
0:30 Integer Function Method
2:15 Creating a PivotTable for Time Analysis
3:00 PowerQuery Method
4:45 Refreshing Data with PowerQuery
5:30 Conclusion

Don't forget to subscribe and ring the bell for more Excel tips and tricks! Check out my online training classes for Excel, Teams, OneNote, and Copilot.

Let me know in the comments which method you prefer: Integer function or PowerQuery!

#Excel #PowerQuery #DateTimeSeparation #ExcelTipsAnd make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[AugustineAKamara]

That's fantastic, thank you so much!