Hi,
I have a column named "Elapsed Open Time' and the data is in the format HH:MM:SS.
The HH is not restricted to max limit of 24. So, a sample data is "34:20:12" meaning the particular record is 34 hours 20 min and 12 seconds old.
I need to extract the HH value alone(in this case, only...