pcmansf Posted March 6, 2008 Share Posted March 6, 2008 Hi there, I'm using this data logger: http://www.omega.com/pptst/OM-CP-PRTEMP101.html Date time comes out of this device as this: 39400.82848 when I paste it to excel and change cell format to date/time this is what I get: 11/14/2007 7:53:01 PM. Does anyone know about this format? How do I convert this number to actual date/time? Device's manual says that date and time are stamped. I'm not sure what it means. Please help. Thanks a lot! Link to comment https://forums.phpfreaks.com/topic/94659-datetime-stamp-format-help-3940082848/ Share on other sites More sharing options...
fenway Posted March 6, 2008 Share Posted March 6, 2008 sounds like day number since the epoch plus fractional days. Link to comment https://forums.phpfreaks.com/topic/94659-datetime-stamp-format-help-3940082848/#findComment-484937 Share on other sites More sharing options...
pcmansf Posted March 6, 2008 Author Share Posted March 6, 2008 sounds like day number since the epoch plus fractional days. You are indeed a genius! First number is the number of days since December 30, 1899 - Microsoft Excel's epoch date and the second number after the dot is a fractional number of seconds (0.864 seconds per digit). Thanks a lot for pointing me in the right direction! Link to comment https://forums.phpfreaks.com/topic/94659-datetime-stamp-format-help-3940082848/#findComment-485226 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.