Greetings,
after spending many hours and days trying to fix this problem, i could not solve it and i am here asking for your help
I am looking for a way to control the inactivity of people in my irc channel/server.
So, what i do is:
1- in irc i do a "/msg nickserv info XXX" the output information would look like this.
Jul 10 00:02:17 -NickServ- XXX is ZZTTRR
Jul 10 00:02:17 -NickServ- Time registered: May 28 21:40:13 2008 UTC
Jul 10 00:02:17 -NickServ- Last seen time: Jun 28 23:13:44 2008 UTC
Jul 10 00:02:17 -NickServ- Last quit message: Quit:
Jul 10 00:02:17 -NickServ- ZZZ is UUUTTTDDD
Jul 10 00:02:17 -NickServ- Time registered: May 28 21:40:13 2008 UTC
Jul 10 00:02:17 -NickServ- Last seen time: Jun 28 23:13:44 2008 UTC
Jul 10 00:02:17 -NickServ- Last quit message: Quit:
Good, with replace, i ge rid of useless info, like the last message rolls.
Jul 10 00:02:17 -NickServ- XXX is ZZTTRR
Jul 10 00:02:17 -NickServ- Time registered: May 28 21:40:13 2008 UTC
Jul 10 00:02:17 -NickServ- Last seen time: Jun 28 23:13:44 2008 UTC
Jul 10 00:02:17 -NickServ- ZZZ is UUUTTTDDD
Jul 10 00:02:17 -NickServ- Time registered: May 29 21:40:13 2008 UTC
Jul 10 00:02:17 -NickServ- Last seen time: Jun 20 23:13:44 2008 UTC
So, now i created a formula to:
*1* print in a specific column (Name), the nick (XXX and ZZZ). (I am not interested in the is ZZTTRR and is UUUTTTDDD)
*2* print the date registered in another column (Registered)
*3* TODAY() - "the printed registered date" in another column (Age)
*4* print the last seen date to another column (Last seen)
*5* TODAY() - "the printed last seen date" in another column (Inactivity)
Everything seem to be working really good.
The problem is that in the dates printed on *2* and *4* are not being seen as dates, so the TODAY()- "the cells" (on *3* and *5*), wont work, because "TODAY()- Apr 12,2008" is not possible ?
what am i missing here . . . ?
Please, i believe the BIG formula is correct . . .
edit,
between, i forgot to mention that the output text is not always in the same "format".
Sometimes, this pops up:
Jul 14 17:58:54 -NickServ- JJJJJ is New Now Know How
Jul 14 17:58:54 -NickServ- JJJJJ is currently online.
Jul 14 17:58:55 -NickServ- Time registered: Apr 19 17:51:30 2008 UTC
So, i had to tell Excel that online=today
Anyway, i worked this out too . . .
Bookmarks