Time format problem
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
|