Excel - IF Function Problem - Expert Solution

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
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
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
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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc