View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ron
 
Posts: n/a
Default How can you strip the time of day out of a date field

I'm trying to sort by the time of day. Because the date and time field are
part of the same number the worksheet sorts by date then time.
Any suggestions ?