Timestamp in Excel - Seconds won't appear
I am trying to use the time stamp function in excel (Ctrl - Shift -but I only allows me to see the hh:mm when the time is added.
Ex. 11:11:00 AM
I tried to change the format from Time to Custom and put it in the h:mm:ss AM/PM format but even adding that formatting to the cell won't show the seconds.
How can I get the timestamp function to add seconds so the formatting is once again Ex. 11:11:11 AM?
Thanks
Unless you use VBA, you can't!! Excel will only give you hh:mm with the shortcut. is VBA any use to you?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks