Sorting Billable Time by Time Spent


This seems to be a bug, not sure if we can make any settings changes to make this work. I’m trying to sort the billable time by Time Spent column, however, this field does not seem to be numeric, which is not sorting the time correctly. E.g. I’d like to see entries sorted as 2h, 4h, 8h, 10h, 12h, etc. However, I see it sorted as 10h, 12h, 2h, 4h, etc.

Is there a solution to this ?

Thank you.

First of all time spent is a custom field and if you want to get it sorted right you should use something that can be sorted such as 10h is 600 minutes. So use 600, etc. this may help sorting it. but use something like 000600 (10h) and 000720 (12h) on 000120 (2h).

Time spent is a default field for billable time. However, the sort order is alphanumeric since the field contains text combined with numbers.

1 Like

While your observation is correct, @aqtms, it is interesting to note that the behavior only shows up if you enter time with more than a single hour digit. Things work fine until you go past 9 hrs 59 minutes.

You could also enter all time only in minutes. Thus, 10 hrs 5 minutes could be entered as 605 minutes. Manager handles the math and sorting just fine.

Thank you, Tut. This solves our problem. We’ll update the time spent in minutes, and I tested invoicing it; the invoice converts minutes to hours as expected.


Hence me advising using minutes…

1 Like