How to quickly determine or extract AM and PM from DateTime string in Excel?
Here is a sheet which contains a list of datetime data, and you cannot quickly determine the datetime is in AM or PM. In this case, I introduce a way to extract the AM or PM from the datetime to the next column to help you easily determine the datetime.
With one simple formula, you can quickly extract and determine AM or PM from the datetime.
Select a cell next to the datetime you want to use, type this formula =IF(MOD(A2,1)>0.5,"PM","AM"), press Enter key, and drag the autofill handle over cells you want to work. See screenshot:
- How to extract time or hour only from datetime in Excel?
- How to extract part of text string from cell in Excel?
- How to extract data from chart or graph in Excel?
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!