Hi there,

I have a huge spreadsheet that is downloaded out of another program every
week listing all staff and their rosters for the week.

The dates and times are imported in these format 2009-04-13,
14.55.00.000000. Is there a way to convert to 13/04/2009 & 14:55 or similiar
so excel recognises as dates and times, other than find/replace?

The data lists each employee as follows:
ID Surname Start Date Start Time Attnd Type End Date End Time
1 Smith 14/04/2009 14:55 STD 14/04/2009 22:30
1 Smith 15/04/2009 14:55 STD 15/04/2009 22:30
1 Smith 16/04/2009 14:55 STD 16/04/2009 22:30
2 Jones 14/04/2009 17:30 STD 14/04/2009 23:30
2 Jones 15/04/2009 17:30 STD 15/04/2009 23:30
2 Jones 16/04/2009 17:30 STD 16/04/2009 23:30



Is it possible to change this to:

Start End Start End Start End
ID Surname 14/04 14/04 15/04 15/04 16/04 16/04
1 Smith 14:55 22:30 14:55 22:30 14:55 22:30
2 Jones 17:30 23:30 17:30 23:30 17:30 23:30