Macro results for time displaying different than expected

hi guys!

I am having some problem with my macro all of a sudden...

here's the macro>>>

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you have a low post count. I also updated your title, and moved your thread. Please take care to do this yourself next time. --6StringJazzer

the supposed output is,

Column A = Name
Column B = Date
Column C = Login time >> format h:mm:ss AM/PM
Column D = Logout time >> format h:mm:ss AM/PM
Column D = employee code

instead I am getting >>> (see Attachment)

Please attach your workbook with the data in the state it is in before you run the macro.

It looks like you have "macro recorder bloat." That obscures what the real problem is. It would help if you describe what your macro is supposed to do.

I will look at your file and see what I can do.

In the meantime:

Originally Posted by Worldbreaker

one question, what's a code tag?

When you post to this board, there are certain "tags" you can insert to affect the way your text is formatted. A CODE tag allows your code to be seen as it would in the VBA window, with spacing preserved. Otherwise, leading spaces and extra spaces are compressed out of your post (just like they are on any HTML page).

So code looks like this without code tags:

Dim i As Long
Dim Count As Long
For i = 1 to 10
If Something Then
DoSomething
End If
Next i

And looks like this with code tags:

Please Login or Register  to view this content.

There are two ways to add code tags. One is to select the code part of the text so it is highlighted, then press the "#" button in the edit controls. The other is to simply type in the tags:

[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]