Hi everyone, In case there was anyone trying to export the GLST.DBM data into Excel. You will need to convert the rtime & mtime from Unix format to Excel format.
For starters, Unix times are calculated as (integer) the number of seconds since 1/1/1970 00:00 Excel times are calculated as (Floating Point) the number of days since 1/1/1900 00:00 So a typical glst exported(dumped) data line looks like this: 70.84.128.4,[EMAIL PROTECTED],[EMAIL PROTECTED];rtime=42bf6b0f,mtime=42 bf701b,mcnt=1,acnt=1\x00 The Rtime and Mtime values are Unix time in HEX. So if you apply the following Excel formula "=(HEX2DEC(A5)/86400)+25568" to the values (in this case Cell A5), you will get the number of days since 1/1/1900 00:00 Then you set the cell format to custom, and display in date/time format "dd/mm/yyyy hh:mm:ss" Excel will display the above example line: Of "42bf6b0f" as 26/06/2005 02:57:19 And "42bf701b" as 26/06/2005 03:18:51 There you go; hope that has helped someone. Rob :-) - To unsubscribe from this list: send the line "unsubscribe xmail" in the body of a message to [EMAIL PROTECTED] For general help: send the line "help" in the body of a message to [EMAIL PROTECTED]
