Thread: DataTime in excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JIM.H. JIM.H. is offline
external usenet poster
  
Posts: 12
Default DataTime in excel
DataTime in excel
I have a DateTime column in A. How do I get this two values?
1. only date in column B
2. Time range in column C like (0-1 oclock , 1-2 oclock, 2-3 oclock €¦)
Thanks,


Reply With QuoteReply With Quote