| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | Total Seconds [t] | Tracks | Maximum Seconds (Soft) [m] | [t/m=%] | Remaining Seconds (Hard) [t-4800=r] | |
2 | 480 | 5 | 4740 | 10.13% | 4320 | |
3 | Box | Seconds +2 | # | Song | Album | Artist |
4 | 120 | Song 1 | Album 0 | Artist -1 | ||
5 | 120 | 1 | Song 2 | |||
6 | 120 | Song 3 | ||||
7 | 120 | 2 | Song 4 | |||
8 | 120 | 3 | Song 5 | |||
9 | 120 | Song 6 | ||||
10 | 120 | Song 7 | ||||
11 | 120 | Song 8 | oh :0 | |||
12 | 120 | 4 | Song 9 | thank you | ||
13 | 120 | Song 10 | ||||
14 | 120 | Song 11 | ||||
15 | ||||||
16 | the formula is an array; it does the whole column from C4 | |||||
17 | 5 | |||||
18 | ||||||
19 | that's awesome thank you so much!! :D | |||||
20 | ||||||
21 | you're welcome | |||||
22 | ||||||
23 | ||||||
24 | ||||||
25 | ||||||
26 | ||||||
27 | ||||||
28 | ||||||
29 | ||||||
30 | ||||||
31 | ||||||
32 | ||||||
33 | ||||||