| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
| Split combined date time data | Excel Discussion (Misc queries) | |||
| Split combined date time data | Excel Discussion (Misc queries) | |||
| Split combined date time data | Excel Discussion (Misc queries) | |||
| split combined Time Date cells | Excel Discussion (Misc queries) | |||
Threaded Mode
