View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Warsteiner
 
Posts: n/a
Default Split date and time

I need a chart that shows just the time in Y and the I am looking for an easy
way to split date and time to creat the chart. The X will just have the days
of each month. This way I can show how many time stamps there are on any
particular day. So far it takes several steps to convert the day/time into
time only or a macro. Maybe some guru has a better idea. BTW the list has
several thousand entries per month.
ArrivalDate
12/1/2005 0:51
12/1/2005 6:27
12/1/2005 14:54
12/2/2005 9:30
12/2/2005 17:32
12/2/2005 21:02
12/5/2005 1:06
12/5/2005 1:23
12/5/2005 15:58
12/5/2005 19:25
12/6/2005 0:05
12/6/2005 4:24