Stumped on this...I am trying to do some reporting off of a badly designed database.
I have a column called 'Hours'. The column is VARCHAR (10) and the data is formatted 00:00
Since it is VARCHAR I am unable to sum up the total grouped by employee.
I am looking to take the column 'Hours' and convert from VARCHAR to DATETIME. I have tried REPLACE, CONVERT, SUBSTRING and I guess I am just not getting the right combination of syntax. I have tried to strip the column into two columns and sum hours and minutes but then I would need some time of calculation to rollover 60 minutes as an hour...too confusing.
So visually I need this