Heres a puzzle
Im using the code shown below to convert a text number into a true excel time, i.e. 1345 into 13:45, well the code changes it to 1:45 pm and then i have to change to display format to show 13:45
Instead of doing this conversion in another column, is there a way via vb or a macro to perform this task on two columns of data with a custom menu button etc.Please Login or Register to view this content.
I want to be able to import my data from a csv file and then click a menu option and have two columns convert to proper time i.e from 1335 to 13:35
Hope that makes sense
G
Bookmarks