Quote:
Originally Posted by Joanna
One question: what kind of custom column and number format would you use for the length of an audiobook? Right now, I am entering the number of minutes but something like 2 h 56 min / 2:56 would probably be nicer (whereas I want to keep the option to sort the audiobooks by length). Any thoughts?
|
If you're careful about how you enter the time, you can use a regular text field. Specifically, use zeroes as placeholders.
For instance, 2:07 for 2 hours 7 minutes. 0:25 for 25 minutes. If you do it this way, sorting the column alphabetically will sort it by length.
This also works if you want to track the seconds as well, even if you track the seconds in some files and not others.
0:03:45 (3 minutes 45 seconds) would come before 0:04 (4 minutes). And 0:00:30 (30 seconds) would come before either.