On Dec 7, 7:20 am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > Hello, > > From a zone-file of a Microsoft Active Directory integrated DNS server > I get the date/time of the dynamic update entries in a format, which > is as far as I know the hours since january 1st 1901. > For Example: the number 3566839 is 27.11.07 7:00. To calculate this in > Excel I use this: > ="01.01.1901"+(A1/24-(REST(A1;24)/24))+ZEIT(REST(A1;24);0;0) (put > 3566839 in field A1 and switch the format of the result-field to the > corresponding date-time format). > > You might guess what I need now: I want to calculate this somehow in > python. > > Sorry, but I couldn't find anything in the module time or something > else to get this calculated. > > Does anyone know how to convert this time in python to something > usable or how to convert this formula in python? > > Thanks a lot and regards > Dirk
I think you want the xldate_as_tuple function in the xlrd module: http://www.lexicon.net/sjmachin/xlrd.htm It works like a champ for me: >>> import xlrd >>> xlrd.xldate.xldate_as_tuple(38980,0) (2006, 9, 20, 0, 0, 0) >>> chad! -- http://mail.python.org/mailman/listinfo/python-list
