I saw this done once, however the VBA code is locked and I cannot look at it. I have been dying to know how this was done. I am fairly certain it is VBA execute on enter, however I do not know for sure.

Here is what happens:

Enter value 6p, or 0600p or 1800 into cell, automatically changes to 6:00 PM

It does this for any time type value entered into the cells. If you just type 0600 it would be 6:00 AM.

This was a scheduling tool that was put together and very VBA/Macro heavy. I am working on a schedule worksheet of my own and it would be nice to be able to utilize this so that the users are not required to use a colon when entering the time.