I have had a go at righting my own query but having a few issues. As per the norm thanks for everyones assistance so far.
/*Create new colunm TimeOnly */
ALTER TABLE ['Job info$']
ADD [TimeOnly] DATETIME NOT NULL
/*Convert [Time Reported] to correct format*/
SELECT ['Job info$'].[Time Reported] ,
[TimeOnly] = CONVERT( TIME , ['Job info$'].[Time Reported] )
FROM ['Job info$'] ;
/*Copy [TimeOnly] to [TimeReported]*/
UPDATE ['Job info$']
SET ['Job info$'].[TimeOnly]=[Time Reported]
/*Remove .0000000 from [Time Reported]*/
The copy TimeOnly is showing a error but i think its something to do with the column is not there so it pulls the error.
Also i am struggling with the last part cleaning the data so its a clean time like 12:48:32 not 12:48:32.0000000
I havent had much input on SQL querys only the very basic's so if it wont work tell me :]