I have a small database of roughly 1300 lines detailing fire-rescue dispatch calls year-to-date. A number of the columns have both dates and times, one for time recieved, one for time dispatched, one for time on scene. Now for some reason the reports that the system produces provide these dates in different formats (sometimes two formats for a single column).
Some of the cells in these columnswill have a numeric date/time code such as: 41275.04 which was set by default to de displayed in a custom format as 1/01/2013 1:00:00 AM. And then some of the cells will have simply text such as 13/01/2013 01:10.
I am attempting to produce a number of metrics and measures from this data and have started by building a filtered dataset which uses simple index/match functions to populate the carryover columns, however I would like to breakdown these date columns into a column with the date of each call and then merely the time stamps for all the others. I cannot for the life of me figure out how to break these missmatched date formats apart without somehow standardizing them. Because of the discrepancies I cannot run a left/find/index/match function to pull the first half or second half of the line as I had hoped.
Any help is greatly appreciated.