J
Janet Kreinbrink
I have a data file where column A = date (as a number value) and column B =
time (in "general" format). Example:
A B
422 1700
423 1350
424 800
425 649
.... ...
Where 422 = 2/13/09 (I know, it's a messed up data file).
and where 1700 = 17:00.
I used the following to change column A to the date:
=DATE(YEAR(TODAY()),1,VALUE(D14)-378)
I used the following to change column B to miliary time:
=TIME(E15/100,MOD(E15,100),0)
But when I concatenate the two result fields, I get: "39863
0.708333333333333 " when I want to get "2/13/2009 17:00."
Changing the date formatting on the field doesn't do anything.
Thanks.
time (in "general" format). Example:
A B
422 1700
423 1350
424 800
425 649
.... ...
Where 422 = 2/13/09 (I know, it's a messed up data file).
and where 1700 = 17:00.
I used the following to change column A to the date:
=DATE(YEAR(TODAY()),1,VALUE(D14)-378)
I used the following to change column B to miliary time:
=TIME(E15/100,MOD(E15,100),0)
But when I concatenate the two result fields, I get: "39863
0.708333333333333 " when I want to get "2/13/2009 17:00."
Changing the date formatting on the field doesn't do anything.
Thanks.