LJlogger file question
Posted 12 June 2003 - 08:03 PM
Posted 12 June 2003 - 08:58 PM
LJlogger does not have an option to change the time format it uses, but you can manipulate the time in Excel as you suggest.
The time is seconds since midnight January 1st (Universal Time), 1904. Many languages have routines to convert this to other formats.
If you are just seeing 3.11E9, you need to expand the column width so you can see all the digits. You also might want to show a couple decimal places.
Many people make a new column where they subtract the initial time ($A$4) from each time, and thus are left with relative time.
By default, Excel stores dates as days since 1900. So to convert the LJlogger times to the default Excel date format, you can divide by 86400 and add 1462. Note that the LJlogger time is Universal Time, so for instance, to convert to local time in Colorado, USA, we need to subtract 7 hours.
We chose to write the time in seconds, because in our opinion it is the most general format and the easiest to work with and perform calculations on.
Here is how you create a column of date/time data in Excel (for an LJlogger data file):
1) Insert a new column after A which Excel will call B.
2) Put the formula "=1462-0.291666667+A4/86400" in B4, and then double-click on the black dot in the lower right corner of B4 to extend the formula to all cells of column B. Note that -0.291666667 is the universal time adjustment for colorado (7 hours / 24 hours per day).
3) Click on B to select the entire column, and go to "Format=>Cells=>Number". Select "Date" for Category and select the desired Type.
Posted 16 June 2003 - 07:36 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users