Would like to know the duration of my whole collection

Tinkering
1

itunes used to show total time of library, (2 years 55 days for instance) I kind of liked the idea that if I were to let it play it would go for years without repeating. :slight_smile:

To that end I thought to export my library to excel and sum the duration column.

But I can’t figure out how the duration number can be converted to hours:minutes:seconds. What is the source tag of duration first off. Or is it stored in Roon DB? I can’t find an album level source, so assume it is being summed on the fly. Or I’m missing it.

Example is a cd with two tracks of 7:18 and 6:55 = 14:13 MM:SS, but the duration on the excel export shows 853.

Thanks for any insight.

2

Maybe to make things simpler.
Go to Roon - Albums
Select 1st album, then select all.
Add to queue
Look at queue - there you have your total duration.
Empty queue

1 Like
3

14 mins and 13 seconds is 853 seconds. Just divide your summed total by 60 and you’ll have the total number of minutes. Divide by 60 again for hours, then 24 for days.

4 Likes
4

I’m intrigued by these 200k collections

At 18 LPs a day, that’s about 3 years no repeats listening?

I’d be thinking ‘I’d quite like to hear that one in the morning about 150 days ago’

3 Likes
5

This does not always work. My queue, for instance, caps out at around 5100 tracks.

6

You are absolutely correct, I stans corrected (mine caps out a little above 5300 tracks)

Not all is lost though

Instead of Adding Albums to the Queue, I switch to Track view, selected all tracks and added them to a new playlist, I called mine AllTracks

image
image1860×382 33.4 KB

I do not get the exact hours:minutes:seconds but I think the 111 days comes close enough to have a good idea about total duration of your library.

Killed the playlist

1 Like
7

LOL, you know, I never noticed the time portion of the playlists details, I only saw or remembered seeing the number of tracks… :slight_smile:

8

Well thanks for all of the input my dudes! Good idea to do the playlist, but I ended up downloading to excel and using DaveN insight that the duration number is seconds. I was overthinking that it was some helpful excel hash number that I had to convert.

Thanks Dave and all!

BTW 3 years 3 months or so. 1189 days.
Happy listnen’ :slight_smile:

3 Likes
9

I only have about 51 days, poor me… :slight_smile:

10

If you are subsribed to a streaming service, you have centuries.

2 Likes
11

True, I was only looking at what was in my library… I have Tidal so I am set for this life and the next few lives I suppose. :wink:

12

Close to a millennium, if you have Qobuz and Tidal. Unless I miscalculated, Qobuz will keep you busy for 600 years, while Tidal will keep you going for at least another 150. And that’s assuming that you listen 24/7.

1 Like
13

Not a competition of course. It’s a journey. :smiling_face:

1 Like
14

Logitech Media Server (LMS) provides such information, in my case:

Anzahl Titel: 102.011
Anzahl Alben: 6.027
Anzahl Interpreten: 19.639
Anzahl Stilrichtungen: 263
Anzahl Wiedergabelisten: 17
Gesamte Spieldauer: 7550:06:51

To have LMS as a backup and for audio books is a nice option anyway.

1 Like