I'm trying to be able to determine how much time I spent listening to certain songs based on multiplying their duration with the amount of times I played them. The Incredible Boom Boom helped me with the math part of it and I modified it to include hours in its display format here:
https://getmusicbee.com/forum/index.php?topic=35695.msg195228#msg195228However, I noticed that the play count it's using to multiply with the songs' combined duration remains static no matter how many songs I highlight. It keeps the first song's play count as the value and multiplies every other songs' durations by that value.
It treats every highlighted song as having, say, 3 plays, multiplying their lengths by 3, when in fact one could have 3 plays, another 6, and another 20.
How can I get it to calculate the songs' "time listened" using their own play counts? Here is the code I'm currently using:
$Split($Div($Mul($Add($Mul($Pad($Split(<Time>,:,1),2),60),$Split(<Time>,:,2)),<Play Count>),3600),.,1) hours $Mod($Split($Div($Mul($Add($Mul($Pad($Split(<Time>,:,1),2),60),$Split(<Time>,:,2)),<Play Count>),60),.,1),60) minutes $Mod($Mul($Add($Mul($Pad($Split(<Time>,:,1),2),60),$Split(<Time>,:,2)),<Play Count>),60) seconds
As you can see in the image above, it's using a play count of 1 for both songs despite the second song actually having 0 plays. The time listened it should be displaying is thus 4 minutes 29 seconds, not 7 minutes 19 seconds.