Suggested by MRTG This timestamp may be converted in EXCEL by using the following formula and choosing the option for the "1904 base": =(x+((365*66+17)*86400))/86400 If the "1900 base" is selected, then change the "66" value to "70". In Excel Date 0.41667 = 10 hours
What I ended up using: =((B25+((365*70+19)*86400))/86400)-0.41667 Sample Spreadsheet extract:
|