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! Quote 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. Quote 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! Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.