close

I want to split a date/time column ie. mm/dd/yy hh:mm:ss AM/PM. Into 2
columns
1. mm/dd/yy and 2. hh:mm

I'm using excel 2003

1. =int(A1), format as date
2. =MOD(A1,1), format as time

--
Kind regards,

Niek Otten

quot;RKMillerquot; gt; wrote in message
...
gt;I want to split a date/time column ie. mm/dd/yy hh:mm:ss AM/PM. Into 2
gt; columns
gt; 1. mm/dd/yy and 2. hh:mm
gt;
gt; I'm using excel 2003

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄