Author |
Message |
Registered: March 14, 2007 | Posts: 1,777 |
| Posted: | | | | I'm thinking child profiles versus parent, like for TV shows. Do we round the individual episodes for the child profiles and then sum them or do we sum exact times and then round at the end? Additionally, do we sum all the rounded child profiles to derive the parent number or do we go with exact numbers for all the episodes and then round at the end? |
|
Registered: April 14, 2007 | Posts: 433 |
| Posted: | | | | Quoting mdnitoil: Quote: I'm thinking child profiles versus parent, like for TV shows. Do we round the individual episodes for the child profiles and then sum them or do we sum exact times and then round at the end? Additionally, do we sum all the rounded child profiles to derive the parent number or do we go with exact numbers for all the episodes and then round at the end? I usually sum up the runtimes for all episodes on each disc and round up/down for the Disc profiles total runtime. I then take the individual discs runtimes before rounding and add them up for the season/set runtime and round it up/down . Surprisingly the rounded runtimes of the disc profiles added up generally match the set runtimes. | | | Chris | | | Last edited: by cmaeditor |
|
Registered: March 13, 2007 | Posts: 775 |
| Posted: | | | | I keep an excel file all set up for this purpose, I just type in the runtimes of the episodes (or play-all option), and then various bits in the template tell me the runtimes for each disc and the set as a whole. Then I just copy the disc/set times to a separate sheet for keeping, just in case. |
|
Registered: March 14, 2007 | Posts: 1,777 |
| Posted: | | | | Okay, perfect. That's what I was looking for. |
|
Registered: March 14, 2007 | Posts: 3,830 |
| Posted: | | | | Quoting Nadja: Quote: I keep an excel file all set up for this purpose, ... Same thing here excel: add all the times in one column in time format, make a sum of that time format of the sum field make a minute rounded conversion: =Hour(A5)*60+MINUTE(A5)+Round(SECOND(A5)/60;0) (where A5 is the reference to the sum in time format) - every hour 60 minutes - get remaining minutes - get the seconds, convert to minute (/60), convert below or above 30 seconds to minute above or below. this gives you the minute running time for each child disc. then you could make a column totaling all minutes/child disc what would give you the Box running time in minutes then you could make a third column totaling all minutes/boxes for grandfather box If you have excel: this is the file: children run time to box to total boxesit is made in excel 2000 (dutch), but it should run on english versions) | | | Sources for one or more of the changes and/or additions were not submitted. Please include the sources for your changes in the contribution notes, especially for cast and crew additions. | | | Last edited: by ? |
|
Registered: March 13, 2007 | Posts: 453 |
| Posted: | | | | Giga,
I dont know Excel very well and am having some trouble.What do I do with B5? I did figure out how to enter the data in A1-A4, then I assume I double click B5 until it says Sum at the top and then press Sum? |
|
Registered: March 14, 2007 | Posts: 3,830 |
| Posted: | | | | looks like it does not run in English. If you don't get a result in A5 the formula =SOM(A1:A4) should change to =SUM(A1:A4)
in B5 you find the formula =UUR(A5)*60+MINUUT(A5)+AFRONDEN(SECONDE(A5)/60;0) replace the function names: UUR = Hour MINUUT = Minute AFRONDEN= Round SECONDE= Second
so the formula should look like this, copy and paste line in to B5 =Hour(A5)*60+Minute(A5)+Round(Second(A5)/60;0)
if it still not works it could be the delimiter ; change that to , copy this one in to B5 and it should work: =Hour(A5)*60+Minute(A5)+Round(Second(A5)/60,0)
usage enter episode running time in a1-a4 Cell A5 should give you the total time. B5 should give you the time in minutes. The result of B5 copy this to c1 for first dvd, c2 for second dvd , ..., C7 for dvd seven. C8 gives you total time in minutes for the Box. If you have collection box with boxes of DVD's (grandfather profile). You can take the result for DVD box 1 in C10, DVD box 2 in C11, ..., DVD Box 10 in C19. The result in C20 would be total running time for the box with dvd boxes. | | | Sources for one or more of the changes and/or additions were not submitted. Please include the sources for your changes in the contribution notes, especially for cast and crew additions. | | | Last edited: by ? |
|
Registered: March 14, 2007 | Reputation: | Posts: 1,819 |
| Posted: | | | | Alternatively.... Use paper and pen Write down the run times of each episode - add them together and you'll get the runtime. Simple. |
|
Registered: March 14, 2007 | Posts: 3,830 |
| Posted: | | | | indeed, why don't you put your collection on paper | | | Sources for one or more of the changes and/or additions were not submitted. Please include the sources for your changes in the contribution notes, especially for cast and crew additions. |
|