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, press enter, automatically changes to 6:00 PM
It does this for any time type value entered into the cells. If you just type 0730 it would change to 7:30 AM once you press enter or move to the next cell.
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. I have tried just cell formatting but no matter what I make the cell format it will not recognize time entry unless it is entered as 6:00 (pm optional).
Here is what happens:
Enter value 6p, or 0600p or 1800 into cell, press enter, automatically changes to 6:00 PM
It does this for any time type value entered into the cells. If you just type 0730 it would change to 7:30 AM once you press enter or move to the next cell.
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. I have tried just cell formatting but no matter what I make the cell format it will not recognize time entry unless it is entered as 6:00 (pm optional).