Can't convert the time

ITmajor has asked for the wisdom of the Perl Monks concerning the following question:

I have some text files that record time using the excel serial date format. When I try to use DateTime::Format::Excel, it doesn't convert the time portion. For instance, for this value 39547.62534167, only 39547 is converted to a date and the time is completely ignored. How do I get the program to convert both the date & the time?

Comment on Can't convert the time

Replies are listed 'Best First'.
Re: Can't convert the time by toolic (Bishop) on Jul 21, 2008 at 19:15 UTC
A quick check of the bug reports on CPAN shows this, which looks relevant to your issue: DateTime-Format-Excel does not convert the seconds portion of an Excel Date/Time value	[reply]
Re^2: Can't convert the time by ITmajor (Beadle) on Jul 22, 2008 at 14:24 UTC
thanks, it works!	[reply]

Back to Seekers of Perl Wisdom