I want to take the data from a cell that is in the format dd/mm/yyyy hh:mm:ss and extract just the time element so that I can sort on time alone. Any ideas
I want to take the data from a cell that is in the format dd/mm/yyyy hh:mm:ss and extract just the time element so that I can sort on time alone. Any ideas
Maybe
VBA Noob=TEXT(A1,"HH:MM")
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
An alternative
=A1-INT(A1) format cell to TIME
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks