Home › Forums › Mooshimeter Support › How to convert CSV? › Reply To: How to convert CSV?
November 30, 2015 at 2:04 pm #6029
Guest
Update: I Figured it out!(with some help) It is simple rocket science. Here goes:
The meter bases it’s date from 0:00 GMT 1-1-1970. Excel Starts from 1-1-1900. So all you have to do is add the number of seconds from 1945 to your date (70 years or 2208988800 seconds) and then the number of seconds from GMT (I am on Pacific time -8 hours 8 * 1440 = 11520) So if your value is in cell A2, your formula for Pacific time is =(A2+22089888800-11520)/86400 Your result: 42331.4854923495 Then you apply the cell format user type MM/DD/YYYY HH:MM:SS.000 Your result:11/23/2015 11:39:06.539 Good Luck!