Managing a time duration as a filter

[datamgmt]

I am parsing a massive number of .m4a files and want to find any that are longer than 10 minutes (600 seconds)

Every file has a tag 'MediaDuration' populated by MusicBrainz, and the format is HH:MM:SS, so my working assumption was HH*60*60 + MM*60 + SS > 60*10 as a filter in the if column, so I tried:

Code Select Expand

exiftool -if 'int(substr($MediaDuration,0,2))*60*60 + int(substr($MediaDuration,3,2))*60 + int(substr($MediaDuration,6,2)) > 60*10' -filename -r .
Can anyone please advise me on what I am doing wrong?

[greybeard]

Hopefully its much easier than that - you should be able to do something like this:

exiftool -if '$MediaDuration# > 600'  -FileName -r .

[StarGeek]

What is the error returned by exiftool?  What OS are you using?

I don't see anything wrong with the command as long as you are using Mac/Linux. If you're on Windows, swap the quotes and switch to CMD. PowerShell fails with complex exiftool commands such as this.

[datamgmt]

Thanks

This did the trick

exiftool -if '$MediaDuration# > 600'  -FileName -r .

For reference, I am on a Mac Studio (Apple Silicon) running macOS Sonoma 14.5