This my problem:I got exel sheet which is populated from .txt file a list of song names,artists, start time of song.My problem is how to get duration of each song in separate column labeled duration by substraction B5-B4, B6-B5 and so on, but in somehow in automated sense, because i got several thousend song.
Example sheet:
A B C D
Start Artist Song Title Duration
0:50:37 REM Pop Song ?
0:53:50 Gang of Four Man in Uniform ?
Thanks
Bookmarks