View Single Post
Old 09-13-2022, 09:25 AM   #575
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,766
Karma: 30237628
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by chaley View Post
I thought of that then rejected it as too complicated because it is actually a date column, not a duration. It isn't clear to me how it will work over time, for example for sorting, and whether arithmetic would work. I am sure that one must guarantee that the date portion is always the same date and that the timezone never changes. Possibly 01-01-0101Tmm:dd:ssZ would do.

That said, I am glad it works for you.
I've never wanted to sort on it, much less do arithmetic. If I wanted to do something like that I'd create a csv and use Excel. I also use the column as a hook on which to hang an icon.

But wait, I just did a sort on my duration column - perfect.

Click image for larger version

Name:	Screenshot 2022-09-13 231624.jpg
Views:	807
Size:	25.2 KB
ID:	196491

And then I remembered the sort_dates_using_visible_fields tweak takes care of it. Perhaps there should be a companion tweak zero_non_visible_fields_in_dates.

BR
BetterRed is offline   Reply With Quote