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
Bookmarks