Hi All,
I was wondering if it is possible to remove the date from a timestamp. I have a worksheet with thousands of rows, and don't want to manually do it.
The date currently shows like this: 04/20/09 7:30:00 AM
I just want the 7:30:00 AM portion. I can reformat the cells to show only the time, but the value still have the date.
Does anyone know if this is possible?
Thank you
One way without formulas...
Convert your column to General so you have decimal values,
then select the column and go to Edit|Replace
and replace
*. (that's an asterisk and period)
with
. (that's a period)
click Replace All.
Then reformat to Time.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks