Ophir Optronics Ltd QSR Manual De Usuario

 

6.  In the Delimiters area, check Tab (the default) and Other. In the text box 

to the right of Other enter the colon symbol (":"). 

7.  Click Finish. 

The log file opens in a spread sheet, with four active columns. 

Column A contains the energy measurements.  

• 
• 
• 
• 

Column B contains the hours from the timestamp.  

Column C contains the minutes from the timestamp.  

Column D contains the seconds and fractions of a second from the 

timestamp. 

8.  If the log contains timestamps longer than 59 seconds and accurate 

timestamps are required: 

a.  Calculate the total seconds in Column E. Apply the following formula to cell 

E1: "= 60*60*B1 + 60*C1 + D1". 

b.  Drag the cell to any additional rows to apply the formula and calculate the 

total seconds for those rows.  

Accurate timestamps appear in the fifth column of the log file.