How to add custom ordering to a column with continuous data
Is there a way to add custom ordering to a column of continuous numbers? I have a column that stores the start time for a given work order. The times are stored as numbers in 24 hr format with the leading 0's removed (e.g. 12:05 am = 500; 3:26 am = 32600; 7:14 pm = 191400). Each work order has multiple entries, and I am tabulating the data, grouping by work order, and displaying the minimum begin ...