Thread: How to extract time and date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hemanth Hemanth is offline
external usenet poster
  
Posts: 1
Default How to extract time and date
Hi All,

How to extract time and date from a date time value.
Ex : 2/2/2007 14:00 , i need the date and time in sepearte cells, how do i
go about doing it, please advice.
Reply With QuoteReply With Quote