How did you enter the time?
If you enter =NOW() in cell A1 and format it as "hh:mm:ss.00" you will see the seconds and hundredths.
Click f9 to update the time.
As to the macro, perhaps if you said what you wanted it to achieve, someone could help you.
If you have found 'formulas' that do what you want, but don't know how to use them, why not include them in your post.