Time format problem
O.k.
so you might try to convert this column with
=INT(A1)
copy this down and format this column as 'Time'
--
Regards
Frank Kabel
Frankfurt, Germany
sandy wrote:
thanks sandy, i found the reason!
9:00:00AM was displayed as 4292552277.375 in excel
actually only .375 is useful, 0.375 = 9:00:00AM !!!
i think the programmer added some time stamp before the
dot.
Thanks for reminding me time is less than 1.0
|