![]() |
|
#1
|
|||
|
|||
|
I have a spreadsheet that has stumped me maybe someone can help. The spreadsheet deals with videos and has an extra unit for hours, minutes, seconds and frames. The last frame is always zero zero as per 01/10/2015 00:00:00:00 00:00:46:00 BEAUTIFUL MUSIC BEAUTIFUL WORLD Consisting of date, start time, playing time (0hours,0minutes, 46seconds and 00 frames for the title beautiful World. I wish to import a file which will convert the 00:00:46:00 to digital minutes. I have tried =(HOUR(RC[-5]) * 60 + MINUTE(RC[-5]) + SECOND(RC[-5]) / 60)/60 but it does not work? The field is formatted as a 'general' format at source Any help appreciated regards ogmium |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Why only 3 minutes audio recording
|
rfwltd | OneNote | 1 | 10-29-2016 01:42 PM |
Calculate Average Time Elapsed in Days, hours and minutes
|
Nina46 | Excel | 9 | 09-11-2015 02:09 AM |
| turnaround time minutes divided by volume | tweeter | Excel | 9 | 11-18-2013 02:09 PM |
| Forward Unread Messages after X Minutes? | BamaBrad | Outlook | 2 | 03-13-2011 07:57 AM |
Documents Take 5 Minutes To Open
|
Farrar | Word | 1 | 07-23-2007 02:54 PM |