Hello all!

I have a data multi-variable data set that I would like to use with STATA.
Two of my variables, date and time, are causing me a bit of trouble as they show up as "strings" when I import them into STATA.
I have then "formatted" them within STATA but the new time variable happens to include the year "1960" on all entries.
Does anyone have any experience dealing with this?
Is there anything I can do within Excel to aid this?

Tips are much appreciated.