One way, assume the range with films are called MyRange (replace it with
cell references like A1:A1000 or something), then you can get the mm:ss like

=INT(SUM(MyRange)/1.66666666)/24/60/60


--

Regards,

Peo Sjoblom

"a_dunn69" wrote in
message ...

I was wondering if anyone might be so kind as to help me with a formula.
I currently have 1000s of film items entered on a spreadsheet with
length indicated by number of feet. I know that each 1.66666666 feet is
worth one second of running time. Is there a way to just apply a formula
and have results displayed as mm:ss rounded to the nearest second?
AD


--
a_dunn69
------------------------------------------------------------------------
a_dunn69's Profile:
http://www.excelforum.com/member.php...o&userid=28680
View this thread: http://www.excelforum.com/showthread...hreadid=483597