Sorting HH:MM:SS accurately

Question

Hi Team, seeking help from someone to sort the time in data accurately, All the other fields should be sorted in Ascending order. But the Processing time column is not sorting as expected. Attaching the data for reference

Also, my workflow as well. I am expecting an output like this

Job Execution.yxmd

Demo.xlsx

Gaurav_Dhama_ · Answer

As @caltang mentioned, sorting is working correct. What you see not sorting is because it's by level.

For example, in below screenshot,

Start date is same, so go to next level

Process type, E comes first so it is first, then words starting with I.

now first, line is irrelevant for the second and third line, because by second layer of sorting it will always be first line.

Next level, Process, Daas comes in dictionary before Daily, hence these three lines are sorted by level 3. No more sorting will make any difference.

Hence you see that the time is not coming out sorted.

Now you always have to sort by fields that matter first, then second and so on.

Hope that helps.

caltang · Answer

I don't get it. Your sort is working as intended. Unless you want the Process Type to be the main one?

In that case, try this:

To get this: