Question description:
This user has given permission to use the problem statement for this
blog.
I want to be able to record timestamps in excel in the format h:mm:ss AM/PM. I am using the keyboard shortcut "ctrl+shift+:" because I need to be able to record it quickly. But the result is in hours and minutes with no seconds. And if I format the cell before or after to include seconds, it just shows 00 seconds. Please help me.
Solved by K. L. in 13 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
27/02/2018 - 05:22
Hello, I understand that you would like to have a time stamp that shows the seconds, right?
User
27/02/2018 - 05:22
yes
Excelchat Expert
27/02/2018 - 05:22
Before we proceed, this is a reminder that our policy is 1 question per session so for this session we'll be resolving this particular question.
User
27/02/2018 - 05:22
okay
Excelchat Expert
27/02/2018 - 05:23
Okay, there are 2 ways to handle this, the first one will be to use VBA/Macro.
Excelchat Expert
27/02/2018 - 05:23
It's the best approach to this but unfortunately, we don't support this at the moment.
Excelchat Expert
27/02/2018 - 05:23
The next best thing is to use a formula.
Excelchat Expert
27/02/2018 - 05:24
After using the formula, we'll then be pasting it as values so it gets stamped.
Excelchat Expert
27/02/2018 - 05:24
Here are the steps on how to accomplish a time stamp:
Excelchat Expert
27/02/2018 - 05:24
Type =now() in the cell where you want the time stamp to be. Then press Enter. Select that cell then copy it by CTRL+C
Excelchat Expert
27/02/2018 - 05:25
Then paste it in the same cell as values, to do that you can right-click the cell then select Paste Special Values.
Excelchat Expert
27/02/2018 - 05:25
Of course the cell has to be formatted to show the SS so make sure of that.
User
27/02/2018 - 05:27
That worked, but that seems like a lot of work if Im trying to do it quickly
Excelchat Expert
27/02/2018 - 05:27
I'm afraid so. Unfortunately, that's the only way to do it using formulas if you really want the seconds to show.
Excelchat Expert
27/02/2018 - 05:27
But, like what I mentioned, this isn't really the best way.
Excelchat Expert
27/02/2018 - 05:28
The best way to do it is still to use VBA/Macro.
Excelchat Expert
27/02/2018 - 05:28
You may want to search about VBA timestamp Excel as I'm sure you'll get lots of resources about that as it is a common request.
User
27/02/2018 - 05:28
I don't know how to use VBA/Macro
Excelchat Expert
27/02/2018 - 05:29
We used to support VBA/Macro but I must apologize because we currently do not support it.
Excelchat Expert
27/02/2018 - 05:31
Still with me?
User
27/02/2018 - 05:31
yes
User
27/02/2018 - 05:32
is there any other program I could use that would help
Excelchat Expert
27/02/2018 - 05:32
Excel itself has the capability, it's called VBA/Macro. It allows you to automate the timestamp without any input.
User
27/02/2018 - 05:34
I have already googled vba/macros and timestamp for excel before I contacted you and I could not find anything to help. So I guess I will have to find a better program to help me
Excelchat Expert
27/02/2018 - 05:34
By better program, I don't think you can find anything useful outside of Excel as Excel is itself capable of what you need.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
