Having an EPOCH time with Cisco CDR. June 16th, 2011
Find yourself trying to decipher your Cisco CDR exports? Your not alone. I’ve got to give credit to some folks who helped me out – especially since I’m using Excel for MAC 2011.
Found this on Blindhog.net – smart guys!
Are you using Excel for MAC 2011 and find your year is off by 3?
You actually need to change the hack digits at the end of your formula from 25569 to 24107.
Check out this link.
Also, I was struggling with getting my human date and time to match that on www.epochconverter.com using the formulas above. It was off by 3 or 4 minutes. I found that if I removed the outermost set of parenthesis, then my formula actually matched the exact minute, as verified in the picture below.
Hope this helps some of you out rather quickly. Enjoy.
BTW, using the eastern time formula above, I was still off a little, so I simply added another hour (4*3600).
This week I will be at the shore…did I bring my Sunblock? August 13th, 2007
I am sure that at this point most of you have had some sort of experience with VOIP. My personal experiences are very mixed. On the Enterprise side I have worked on a multi-million dollar install of Cisco VOIP on a new all Cisco Network and it was less than spectacular. As a consultant I have worked with Cisco’s Call Manager Express in it’s home waters of the small/mid sized business and again I felt that it was lacking. However on the personal side I have been an off and on user of Skype for quite awhile as well as other come and go lightweight VOIP apps over the past seven or eight years. Read the rest of this entry »
