but is that the correct time information (hh.mm.ss) you are looking to send to your mysql database even if the date is in front of it? You could split that on the space and make two variables out of it. -------------------------------------------------

I have a field in Excel with datetime ex. "2007/12/23 23:12:11" Once it is a variable in Perl it's a unique number 208962,121320000. This contains every information. There is a function: datetime:format:Excel which gives me the date!!! That's fine so i can write it to MySql!! But an other field in Excel is the time but... I don't know how to get that...

Excel stores dates and times as a floating point number. The integer is the number of days since Jan 1st 1900 and the decimal part is a fraction of a day (.0 is midnight, .5 is noon, etc).

DateTime::Format::Excel takes a number in this format and converts it to a Perl DateTime object. Once you have the DateTime object you can use any of its methods to get the date and time in whatever format you like.

The documentation for DateTime::Format::Excel has an example that uses the "ymd" method to get the date. But you can also use the hms method to get the time. Or any of the other myriad methods of the DateTime object.