Copy duration attributes in finder

Hi Cipiatone,

If you are working with iMove or Final Cut Pro X, you could look at your clips in "list view" and copy / paste the information into another document. Otherwise, just taking screenshot of the Finder window would give you a copy of the information you need.

How to take a screenshot on your Mac

Take care,

This Automator Workflow will copy the Duration in seconds to your clipboard

mdls -name kMDItemDurationSeconds -raw "$1" | pbcopy

If you also want to copy the name of the file with the duration (in seconds):

mdls -name kMDItemFSName -name kMDItemDurationSeconds -raw "$1" | xargs -0 printf "%s \t" | pbcopy

To convert the duration in seconds to: hh:mm:ss, divide by 86400 and then ⌘1 and Format as Time-> hh:mm:ss

And to have this work as a 'right-click', select in Finder, when you open Automator, select "Service" instead of Workflow.

Expanding on the above Automator Workflow, this Automator Service will allow multiple movie files to be selected in Finder, then right-clicking and selecting the Service name will copy the Filename and Duration (in seconds) to the clipboard. Then after pasting into Excel, convert the duration in seconds to: hh:mm:ss, by dividing by 86400 and then ⌘1 and Format as Time-> hh:mm:ss

TMPFILE=$(mktemp -t temp)

for f in "$@"

do

mdls -name kMDItemFSName -name kMDItemDurationSeconds -raw "$f" >> $TMPFILE

echo >> $TMPFILE

done

cat $TMPFILE | xargs -0 printf "%s \t" | pbcopy

rm $TMPFILE

A little bit of an improvement.

This will add the divide duration in seconds by 86400 to the clipboard, so that all that will be needed is to Format the cell as HH:MM:ss in Excel:

TMPFILE=$(mktemp -t temp)

for f in "$@"

do

echo -n $( mdls -name kMDItemFSName -raw "$f" )$'\t' >> $TMPFILE

echo "=$( mdls -name kMDItemDurationSeconds -raw "$f" )/86400"$'\t' >> $TMPFILE

done

cat $TMPFILE | pbcopy

rm $TMPFILE