335a | 931a |

412a | 1015a |

511a | 330p |

525a | 416p |

330p | 850p |

<tbody>

</tbody>

I figured out how to do it in several steps but I actually have 3000 lines of data and I had to manually type in the times to make sure they were am or pm. Can this process be automated?

I am comfortable with formulas and VBA so a solution either way would be great.

Your help is greatly appreciated and Thank You in advance.