How to Calculate Your Total Time Listening to Your iTunes/iPhone/iPod

A couple of days ago, I wondered what percentage of my life I listen to music. Fortunately, I figured out exactly how to calculate it. I have been using iTunes since I got my first iPod for my 18th birthday in 2005. Three computers and four iPods later, I have managed to preserve my playcounts for the last eight years. A little bit of Excel handiwork revealed that I have spent about 450 days listening to that music, or about an eighth of all my time. That’s about a quarter of all my waking hours!

Want to calculate your time? Here is the process in ten steps. If you have even the slightest experience with formulas in Excel, this will be painless:

1) Open your iTunes and go to your songs tab. Make sure iTunes is showing a column for Time and Plays. (If it isn’t, you can fix this by right clicking on the columns and checking the appropriate categories.)

2) Press CTRL+A to highlight all the songs and then press CTRL+C to copy them.

step 2

3) Open Excel and press CTRL+V to paste all the information. Surprisingly, the information nicely conforms to the cells.

4) iTunes gives a lot of information superfluous to our purposes. Ignore everything but the column for Time and Plays (columns B and I for me).

step 4

5) Create a new column by multiplying the time column by 24.

6) Highlight your new column (column K for me) and use the drop down formatting menu to convert it to a number.

step 6

You might be thinking “why on earth are we doing this?” for the last two steps. Good question. This is part is fancy, so bear with me. Excel treats the time column as a time of day rather than a number of minutes and seconds. For example, it thinks cell B1 refers to 5:09 AM, not 5 minutes, 9 seconds. Excel stores this information as a proportion of a 24 hour day. As such, it thinks of 5:09 AM as approximately 0.21458. Multiplying by 24 and converting it to a number gives us the number of minutes each song is.

7) Create a new column by multiplying the previous new column by the Plays column. (For me, this is multiplying column I by column K.) The result is the total number of minutes you have listened to each song.

This in itself is interesting, and you can use Excel to sort the songs by the most time you have spent listening to them. This list can be quite different from your most played songs, as a 5 minute song counts for twice as much as a 2 minute 30 second song.

8) Use the SUM function to sum the column you created in step 7. This is the total number of minutes you have spent listening to iTunes.

step 8

9) Divide by 60 to get the number of hours you have spent listening to iTunes.

10) Divide step 9 by 24 to get the number of days you have spent listening to iTunes.

Can anyone top 450 days? Post your times in the comments below…

15 responses to “How to Calculate Your Total Time Listening to Your iTunes/iPhone/iPod

  1. Stumbled upon this looking for information about total time of iTunes libraries. Fun and nerdy. Maybe you need a last.fm account? ~ http://www.last.fm/user/go4011s

  2. 452.11 days, but I’m sure you’ve topped that by now, given another 8 months. I have my iTunes data saved since Feb. 2005 as well.

    By the way, am I reading your screenshots correctly? You’ve listened to one of your songs over 2000 times? Wow, my top played is just over 100 times. I try to listen to my entire library of songs somewhat equally using smart playlists though.

  3. this is really nice!

    got 31.54 days ๐Ÿ˜ฎ And had the ipod for like half a year.

  4. 115.8 days ๐Ÿ™‚
    thanks for the totorial

  5. Chad Greenswick

    I got 732 days

  6. 240 days and my library dates back to December 2004 ๐Ÿ˜ฆ though yeah, most of my music rates 150-200 listens each

  7. 69 days, been through a few laptops though

  8. 52.3 days since 30 jan 2014

  9. Thanks so much for this! By the way everyone, if you have any songs longer than an hour, this way won’t work for those songs. I just changed my one 2 hour techno mix song manually.

  10. 53,33642 itunes since 2014

  11. 6.1 days since 3 months

  12. 140 days in since Christmas of 2013 (22 months?) so almost a full week every month woowwwwww

  13. 140 days in since Christmas of 2013 (22 months?) so almost a full week every month wowwwwww

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s