Hi 
,
I am using python v3.6 with xlsxwriter. Writing time into excel cell. The problem that I see that the format cell is custom and not Time. I tried using "%H%M%S" in format cell. Also used datetime object and time object instead of string, but in all cases cell format was custom and not Time.
Any idea how can I change it to be Time format cell instead of custom?
BTW, in date I used datetime object with "/" separator and it appeared as date. Maybe I am using wrong format. I tried to use [h]:mm:ss and also hh:mm:ss.
Does anyone has working example that set the time as an time object and not custom?
Thank you for your help ,
Limor
,I am using python v3.6 with xlsxwriter. Writing time into excel cell. The problem that I see that the format cell is custom and not Time. I tried using "%H%M%S" in format cell. Also used datetime object and time object instead of string, but in all cases cell format was custom and not Time.
Any idea how can I change it to be Time format cell instead of custom?
BTW, in date I used datetime object with "/" separator and it appeared as date. Maybe I am using wrong format. I tried to use [h]:mm:ss and also hh:mm:ss.
Does anyone has working example that set the time as an time object and not custom?
Thank you for your help ,
Limor