The number before the asterisk is the date stored as the number of days
since 12/31/1967 (so day 14121 = 08/29/2006).
The remaining number is the number of seconds (and thousandths of
seconds) since midnight. In this case 08:39:50am
[EMAIL PROTECTED] wrote:
I need to convert a Multivalue field to Date and Time format in MS Excel. The
Mutivalue filed has the following description and the value next to that.
Date_Time_Qty: 14121*31190.858
Any suggestion is appreciated.
Thanks.
Krish
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
--
==========================
Jeff Schasny
jschasnyATricochetDOTcom
==========================
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
