Converting LJUD timestamp to IST | LabJack
 

Converting LJUD timestamp to IST

2 posts / 0 new
Last post
RaguDevi
RaguDevi's picture
Converting LJUD timestamp to IST

I have this from the first column ( time stamp ) of my LJUD logged file : 

3689911542.75853

Need to convert this to Indian Standard Time ( UTC + 5.5Hrs) upto millisecond precsion. 

Thanks

LabJack Support
LabJack Support's picture
The LJLogUD timestamp is

The LJLogUD timestamp is discussed here:

https://labjack.com/support/software/applications/ud-series/ljlogud/ljlo...

The page goes over timestamp conversion in a spreadsheet, with a demonstration in OpenOffice Calc (formulas apply to Excel also).

Note that the conversion is for UTC -7 where we are located, so adjust the conversion formula for + 5.5 hours (+ 0.229166667 days) instead of - 7 hours (- 0.291666667 days). The demonstration formats time to MM/DD/YYYY HH:MM:SS , which is down to seconds. Use a custom format like MM/DD/YYYY HH:MM:SS.000 for milliseconds (the .000 is milliseconds).