Hi Don,

To separate the AM/PM from the time in column B, you can use the Text to Columns feature in Excel. Here are the steps:

1. Select the column B that contains the time entries.
2. Go to the Data tab in the ribbon and click on Text to Columns.
3. In the Text to Columns Wizard, choose Delimited and click Next.
4. In the Delimiters section, uncheck all the boxes and click Next.
5. In the Column data format section, choose Time and select the format that matches your time entries (e.g. 1:30 PM).
6. Click Finish.

This will separate the time and AM/PM into two separate columns. You can then delete the original column B if you no longer need it.