How to write time in excel field?

Question

Python

Hello, I am using the xlwt library to generate an excel file.
I need to write timedelta objects in excel in the "time" format, tell me how this can be done?
Thanks for answers!

Answer 1

1. Write the time as a double in the format “1 day = 1; 1 second = 1/86400".
2 is the easy way. _{Apply one of the predefined number formats (I think 2E 16} = [h]:mm:ss over 24 hours works best ).
2 is the hard way. Play around with format strings.

Answer 2

Generate the desired template in exel and output from it.