Page 1 of 2

What % of your time do you spend on CCJ?

Posted: Mon Jul 04, 2011 9:54 pm
by BrownSound
So, Mattigins as added a great new feature to our profiles which tells us how much time we have spend logged on here. This made me wonder, how much time as a % of the time I have been a member have I spent online...

To calculate simply do the following in excel:

1. In cell A1 enter the date you joined CCJ in dd/mm/yy format
2. In cell A2 type "=today()", this will give you today's date.
3. In cell A3 type "=A2-A1"
4. Whilst on cell A3 change the cell format to "number", this will give you the number of days you have been a member
5. Now calculate how long you have been a member in days (use some general knowledge eg 365 days in a year, 7 days a week) and type it into cell B1
6. In cell B2 type "B1/A3"
7. Whilst on cell B2 change the cell format to percentage.

--------------------------

So far I've spent ~17.8 days online, and have been a member for 144 days, so I've spend 12.4% of my time on CCJ.

Just to put that in perspective, I spend approx 30% of my time sleeping and another 30% of my time at work. This leaves 40% of my time as "free-time", out of which over 1/4 of my free time is spent on CCJ.

I know for a fact I don't spend nearly as much time on here as many others, which raises the question... how much of your free time is spent on CCJ?

Posted: Mon Jul 04, 2011 10:11 pm
by Slash
I leave CCJ open while Im at work and sometimes at home.
Active time isnt that high... online time we be quite high! :)

So not sure how accurate this will be for me anyway! :)

Posted: Mon Jul 04, 2011 10:15 pm
by BrownSound
Yeah, I got curious to see how others would compare... ofey stood out a bit, 42% of his time as a member was spent online. I am assuming not all of it is spent "active"... at least I hope not!

Posted: Mon Jul 04, 2011 10:16 pm
by Nick07
I know who will have the most amount of time.

Posted: Mon Jul 04, 2011 10:20 pm
by aspir3
Maybe Tadz's

Total Time Online: 1 Year, 41 Weeks, 6 Days, 22:49:21
Joined: 08 Mar 2009

Posted: Mon Jul 04, 2011 10:22 pm
by BrownSound
Whoa! That's 78%!!!

Posted: Mon Jul 04, 2011 10:24 pm
by BrownSound
Mattigins wrote:I dont understand step 4 & 5.. arnt they the same?


It is just changing the cell format - when you first enter it, it will come up as dd/mm/yy instead of number.

Posted: Mon Jul 04, 2011 10:26 pm
by ofey
42%? Pffft. Can't actually call that commitment, can I?

I have CCJ on one of the tabs of my browser always.
But as many of you know, I'm not always here.

My computer is also on most nights pulling torrents. I am your proverbial media junkie.
I missed out so much of my childhood, I'm always pulling old shows and music.

So the percentages of me being active on here in truth are quite skewed.

Tadz's % is also very skewed as he parks himself here.

Posted: Mon Jul 04, 2011 10:29 pm
by BrownSound
Too bad this isn't Facebook, which can actually tell if you are "active" or just have the site running in the background.

Posted: Mon Jul 04, 2011 10:32 pm
by BrownSound
Mattigins wrote:BrownSound can you please work out mine? its giving me 0%


Days as a member - 1055
Days online - 162.5

% of time spent online - 15.4%

Posted: Mon Jul 04, 2011 10:38 pm
by aspir3
Matt how do you know so much info about all the members?

Total time?

total pages?

total logins?

What else?