On 20/10/06, Stefan Adamovsky <[EMAIL PROTECTED]> wrote:
How is it possible to convert the timestamp in Excel to the format DD.MM.YY
HH:MM:SS
with (A1+7200000)/86400000+25569 for Greenwich time [central american time
should be (A1-18000000)/86400000+25569]
I can get the time in format DD.MM.YY HH:MM - without the seconds!
Anyone an idea how to get the seconds?
Yes - just set up the appropriate Excel custom format ;-)
Try dd/mm/yyyy hh:mm:ss
btw: the function (A1 / 1000 + ( ( 365 * 70 + 17 ) ) * 86400 ) ) / 86400 in the
article LogAnalysis from wiki does not really work!
Best regards
Stefan Adamovsky
*******************************************************
Stefan Adamovsky
Testing and Integration Team
Hellmann Worldwide Logistics GmbH & Co. KG
DCC - Digital Community Center
Hafenstr. 11, 49090 Osnabrück, GERMANY
http://www.hellmann.net
*******************************************************
--
GMX DSL-Flatrate 0,- Euro* - Überall, wo DSL verfügbar ist!
NEU: Jetzt bis zu 16.000 kBit/s! http://www.gmx.net/de/go/dsl
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
