I am trying to convert time that I have in the following format xx:xx:xx to seconds. What I tried was using text-to-columns to put each time segment in their own column and remove the ":". I then do calculations that convert each column. For example the first column is hours so I use the following calculation - CONVERT(P2,"hr","sec"). The problem lies in when the hour time is greater than 12. When the time is for example 13:00:00, the text-to-columns command changes the 13 to a 1. Is there anyway to make sure that the 13 will stay a 13? I could have as many as 3 or 4 digit hour times (example: 111:35:25). Or is there a better way to convert this time to seconds. I have rows and rows of data that needs to be converted.
Any help would be greatly appreciated!!!
Any help would be greatly appreciated!!!