Converting Excel time-format (hours since 1.1.1901)

Max Erickson maxerickson at gmail.com
Fri Dec 7 13:38:28 EST 2007


Dirk Hagemann <DirkHagemann at gmail.com> wrote:

>> Dirk
> Additional to my last posting: if you want to try this out in
> Excel you should replace the command "REST" by the english
> command what should be something like "remainder".

The equivalent in my (U.S. English, 2000) version of excel is called 
'MOD'.

Also, you have misread or miscopied something, or are encountering 
some very strange issue, as when I put your formula in excel, I get 
the following output:

11/27/2307 7:00


max





More information about the Python-list mailing list