Thread: [Solved] Time to digital minutes
View Single Post
 
Old 11-24-2016, 03:13 AM
ogmium ogmium is offline Windows 10 Office 2010 32bit
Novice
 
Join Date: Nov 2016
Posts: 8
ogmium is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Assuming the 00:00:46:00 is in C1, you could use a formula like:
=LEFT(C1,8)*1440
Thank you for a good try. That equals 24 - the correct answer is 0.76 so thats not right I'm afraid

I am looking for digital minutes from the equation. The spreadsheet looks like this and is 60,000 lines long

0 01/10/2015 00:00:00:00 00:00:46:00 BEAUTIFUL MUSIC BEAUTIFUL
1 01/10/2015 00:00:46:00 00:03:03:00 Gone But Not Forgotten
2 01/10/2015 00:03:49:00 00:05:24:00 Why She Swallows Bullets
3 01/10/2015 00:09:13:00 00:06:21:00 Waltz of the Piano No.3
4 01/10/2015 00:15:34:00 00:00:07:00 LITTLE LINK Watching 1080p DE
5 01/10/2015 00:15:41:00 00:03:58:00 Waterfalls
6 01/10/2015 00:19:39:00 00:03:08:00 Xerxes - largo
7 01/10/2015 00:22:47:00 00:03:23:00 Overcome
8 01/10/2015 00:26:10:00 00:00:10:00 STING - HORNS INTO FULL
9 01/10/2015 00:26:20:00 00:01:30:00 MUSIC PROFILE David Lanz - Ra
10 01/10/2015 00:27:50:00 00:00:10:00 ADVERTS INTRO - DEBUSSEY

The column number starts C3


Nick
Reply With Quote