| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Footage to seconds (# to mm:ss).
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting minutes and seconds to calculate a total average | Excel Worksheet Functions | |||
| Sum minutes and seconds to total hours | Excel Discussion (Misc queries) | |||
| How do I convert 00:03:54 to get 234 seconds? | Excel Worksheet Functions | |||
| Convert seconds to minutes and seconds in excel | Excel Worksheet Functions | |||
| convert seconds to minutes and seconds | Excel Worksheet Functions | |||
Threaded Mode
