if @jpkar does not need to use arithmetic for his duration column, he can proceed with the same format (hh:mm:ss) he currently has and it will work well for sorting. He just needs to change the target column datatype to text to avoid the validation error.
|