trancexx Posted October 20, 2011 Author Share Posted October 20, 2011 You are forgiven. JohnOne has nice avatar. Don't tell him I said that. ♡♡♡ . eMyvnE Link to comment Share on other sites More sharing options...
czardas Posted October 20, 2011 Share Posted October 20, 2011 Thanks, I won't do it again. operator64 ArrayWorkshop Link to comment Share on other sites More sharing options...
BaseIT Posted September 6, 2013 Share Posted September 6, 2013 (edited) Bug? When you try to convert with _EPOCH_decrypt() the epoch value 1262390399 (1.1.2010) it returns 1.13.2009. I solved the problem by changing the value 13 to 12 in line 26 : bug: $asDatePart[1] = $i_eFactor - 1 - 12 * ($i_eFactor - 2 >= 13) fixed: $asDatePart[1] = $i_eFactor - 1 - 12 * ($i_eFactor - 2 >= 12) Can you tell me the idea behind the 13? Edited September 6, 2013 by BaseIT Link to comment Share on other sites More sharing options...
trancexx Posted September 6, 2013 Author Share Posted September 6, 2013 Yes I can but it's boring to explain .I'm using >11. ♡♡♡ . eMyvnE Link to comment Share on other sites More sharing options...
BaseIT Posted September 6, 2013 Share Posted September 6, 2013 In case that i_eFactor is not a float value (should not), >11 and >=12 are the same. Maybe you could correct your first entry, for those who don`t look at the second page. Link to comment Share on other sites More sharing options...
trancexx Posted September 6, 2013 Author Share Posted September 6, 2013 Yes sir! ...as soon as I find two minutes. ♡♡♡ . eMyvnE Link to comment Share on other sites More sharing options...
weszzer Posted December 7, 2014 Share Posted December 7, 2014 Hi, I have a file extracted to MS Excel 2010, then the my date-column is showing integer = 1417732821397.44 the original time for this is actually 2014/12/05 06:41:0.000, I used different conversion found on the internet using excel but no luck to convert to the correct time. Then I found this topic about the epoch time conversion using autoit. Can you guys help me please on how to covert this integer to date as per my example above using autoit. Appreciate you help guys. Thank you.. Link to comment Share on other sites More sharing options...
AndyG Posted December 7, 2014 Share Posted December 7, 2014 (edited) 1417732821397.44 is not 2014/12/05 06:41:0.000 imho 1417732821.39744 is 2014/12/04 22:40:andsomething... read http://fczaja.blogspot.ca/2011/06/convert-excel-date-into-timestamp.html Edited December 7, 2014 by AndyG Link to comment Share on other sites More sharing options...
weszzer Posted December 8, 2014 Share Posted December 8, 2014 Thanks for the link. it works but except for the hour which is 4hours advance.. 1418017836357 = 2014/12/08 05:50:36 (should be 01:50:36) Thank you Link to comment Share on other sites More sharing options...
clicked Posted December 8, 2014 Share Posted December 8, 2014 This is an excellent discussion. I learned much about the "unknowability" of exact time by reading the Boost library intro to its date/time module: http://www.boost.org/doc/libs/1_57_0/doc/html/date_time/details.html Link to comment Share on other sites More sharing options...
weszzer Posted December 8, 2014 Share Posted December 8, 2014 I got it! =((A1/1000)/86400)+25569-"4:00" Thank you! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now