Using Office 2007 on Win XP.

I'm mentally blocked at the moment. I have a number like: 396016747358

Which actually is a serialized value of an MS-Excel date and time. I need to
convert this number to its actual equivalent date/time using one or more
spreadsheet formulas.

Can someone help me out with that?

Thanks much in advance.

Assuming by serialized value, you mean the decimal point was omitted and
that the actual value was 39601.6747358, then try this...

=--(LEFT(A1,5)&"."&MID(A1,6,15))

Note: The above, if correct, assumes you will never have any dates before
May 18, 1927 (the first date where the serial value was a 5-digit number).

--
Rick (MVP - Excel)


"XP" wrote in message
...
Using Office 2007 on Win XP.

I'm mentally blocked at the moment. I have a number like: 396016747358

Which actually is a serialized value of an MS-Excel date and time. I need
to
convert this number to its actual equivalent date/time using one or more
spreadsheet formulas.

Can someone help me out with that?

Thanks much in advance.

Thanks Rick, that does the trick; I kept messing around with "Date" and
"Time" functions.

Thanks!

"Rick Rothstein" wrote:

Assuming by serialized value, you mean the decimal point was omitted and
that the actual value was 39601.6747358, then try this...

=--(LEFT(A1,5)&"."&MID(A1,6,15))

Note: The above, if correct, assumes you will never have any dates before
May 18, 1927 (the first date where the serial value was a 5-digit number).

--
Rick (MVP - Excel)


"XP" wrote in message
...
Using Office 2007 on Win XP.

I'm mentally blocked at the moment. I have a number like: 396016747358

Which actually is a serialized value of an MS-Excel date and time. I need
to
convert this number to its actual equivalent date/time using one or more
spreadsheet formulas.

Can someone help me out with that?

Thanks much in advance.