Time VBA problem
Posted by Gerald Marshall on December 01, 2001 9:33 AM
I am a complete novice at VBA procedures, however I have copied a procedure that allows me to enter time in a cell as e.g 1630 and it should automatically convert to 4:30PM.
When I enter 1630 in the specified cell it changes to 12:00PM,and not 4:30PM however when I move away from the selected cell and then return to it, the time then changes to 4:30PM which is correct.
What am I doing wrong?
Any help appreciated.