No, the AM PM in time cells are simply a display "trick". Unless your real data is not what it appears to be. You would need to show me the actual problem workbook.