Excelanalytics v1

Release Notes

Probably runs with all versions newers than 1.0 but only is tested in 1.2 and 1.6

Please add comments with the other versions testings. And add comments with your cruel opinion.

 

  • How to understand the values in column TimeStamp ()... The date and time? What is it? Thanks

    Username
    Url
    TimeStamp()

    abrikos
    /pg/admin/plugins/
    1268436116

    abrikos
    /pg/dbvalidate/
    1268436146

    abrikos
    /pg/profile/abrikos
    1268436180


  • @Abrikos its a Unix TimeStamp

    I dont know how it works. But you can use this online converter to make it human readable.

    http://unixtime-converter.com/

    From the timestamp u gave above, 1268436116 --->   Sat Mar 13 2010 06:21:56 GMT+0700

  • Unix time - Wikipedia
    Unix time, or POSIX time, is a system for describing points in time, defined as the number of seconds elapsed since midnight Coordinated Universal Time (UTC) of January 1, 1970

  • I understand, nice... Thanks...

  • I choose the timestamp and not another datetime formats because it's the most easy way to make mathematical operations. To convert Timestamp in date mm/dd/yyy, you can make a new cell with:

    = 25569 + $C1 / 86400

    ($C1 is the cell whit the timestamp number; 25569 is 1/1/1970 in general format and 86400 is the seconds in a day).

    Press with right button over the new cell, choose "cell format" and "date" and extend this new cell to the all rows (with copy/paste or dragging from the downright corner of the cell).

    You can make another column but choosing "time" in "cell format" options, and can see the time.

    If this explanation not is clear please ask again.

    Thanks

     

  • Its better in datetime formats in my opinion.

  • Ok, I updated the plugin, in the new version, the datetime row contains the information in general format. Thankyou elHayaze.

     

     

migueloni

research, develop, test and publish -Cooperate to create-

Stats

  • Category: Site admin
  • License: GNU General Public License (GPL) version 2
  • Updated: 2014-11-17
  • Downloads: 1134
  • Recommendations: 3

Other Projects

View migueloni's plugins