{"action":"closed","issue":{"url":"https://api.github.com/repos/jmcnamara/XlsxWriter/issues/207","labels_url":"https://api.github.com/repos/jmcnamara/XlsxWriter/issues/207/labels{/name}","comments_url":"https://api.github.com/repos/jmcnamara/XlsxWriter/issues/207/comments","events_url":"https://api.github.com/repos/jmcnamara/XlsxWriter/issues/207/events","html_url":"https://github.com/jmcnamara/XlsxWriter/issues/207","id":53299797,"number":207,"title":"Datetime export not working correctly from pandas","user":{"login":"rschell","id":1888300,"avatar_url":"https://avatars.githubusercontent.com/u/1888300?v=3","gravatar_id":"","url":"https://api.github.com/users/rschell","html_url":"https://github.com/rschell","followers_url":"https://api.github.com/users/rschell/followers","following_url":"https://api.github.com/users/rschell/following{/other_user}","gists_url":"https://api.github.com/users/rschell/gists{/gist_id}","starred_url":"https://api.github.com/users/rschell/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rschell/subscriptions","organizations_url":"https://api.github.com/users/rschell/orgs","repos_url":"https://api.github.com/users/rschell/repos","events_url":"https://api.github.com/users/rschell/events{/privacy}","received_events_url":"https://api.github.com/users/rschell/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/jmcnamara/XlsxWriter/labels/question","name":"question","color":"cc317c"},{"url":"https://api.github.com/repos/jmcnamara/XlsxWriter/labels/ready+to+close","name":"ready to close","color":"bfe5bf"}],"state":"closed","locked":false,"assignee":{"login":"jmcnamara","id":94267,"avatar_url":"https://avatars.githubusercontent.com/u/94267?v=3","gravatar_id":"","url":"https://api.github.com/users/jmcnamara","html_url":"https://github.com/jmcnamara","followers_url":"https://api.github.com/users/jmcnamara/followers","following_url":"https://api.github.com/users/jmcnamara/following{/other_user}","gists_url":"https://api.github.com/users/jmcnamara/gists{/gist_id}","starred_url":"https://api.github.com/users/jmcnamara/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmcnamara/subscriptions","organizations_url":"https://api.github.com/users/jmcnamara/orgs","repos_url":"https://api.github.com/users/jmcnamara/repos","events_url":"https://api.github.com/users/jmcnamara/events{/privacy}","received_events_url":"https://api.github.com/users/jmcnamara/received_events","type":"User","site_admin":false},"milestone":null,"comments":3,"created_at":"2015-01-03T09:55:02Z","updated_at":"2015-01-21T17:00:02Z","closed_at":"2015-01-21T17:00:02Z","body":"Using version 0.6.5 with Pandas 0.15.2 I'm using to_excel to export some dataframes which have a datatime variable as the first column.  I noticed the the exported spreadsheet values only contained daily values when I was expecting hourly values.  I traced to problem to the utility.py module and the  datetime_to_excel_datetime function.  Please check the equation at line 630 it appears to me to be missing delta.hours (and delta.minutes?) portion of the datetime value.  \r\n\r\nThanks for providing this excel interface,  I have tried others and xlsxwriter fulfills my requirements the best."}}