View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
agilek9 agilek9 is offline
external usenet poster
 
Posts: 3
Default Extracting the Time from a Date/Time Stamp

In Excel I am trying to separate a date/time stamp into its component parts
(i.e., date, day of week and time), and place the components into separate
cells so that I can filter, sort and even graph based on this information. I
have figured out how to do the day of the week but I can't figure out how to
extract the time portion of the date/time stamp. Does anyone have any
suggestions. Thanks.
--
agilek9