Mirror Column Sorting Chronologically

Currently a mirrored hourly column will sort as a text column. Even if changing the original column to a 24hr clock the new column ill still sort as if it is 12hr, grouping AM and PM hours together.

Please allow us to change a mirrored column type to hours or remedy this issue in some other way.