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

If you want the dates in one column and the time in the next, you could select
that range and do data|Text to columns.
Fixed width
Choose the correct mdy format for the date
and general for the time

(You may have to format the date column as mm/dd/yyyy if the time 00:00 still
appears there.)

Warsteiner wrote:
>
> 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

--

Dave Peterson

Man, I would have never thought about it. I was making it way to complicated.
Works like a charm!!
Thanks a lot
Warsteiner

"Dave Peterson" wrote:

> If you want the dates in one column and the time in the next, you could select
> that range and do data|Text to columns.
> Fixed width
> Choose the correct mdy format for the date
> and general for the time
>
> (You may have to format the date column as mm/dd/yyyy if the time 00:00 still
> appears there.)
>
> Warsteiner wrote:
> >
> > 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
>
> --
>
> Dave Peterson
>