close

Probably an easy one for you all!

I have a long column of times (cell contents= '9:00PM ) extracted
from another application and I want to subtract another time from them. Is
there an easy way to convert this into a time that excel can use?

thanks
Kazza

=TIMEVALUE(A1), Format as Time

--
Kind regards,

Niek Otten

quot;Kazzaquot; gt; wrote in message ...
| Probably an easy one for you all!
|
| I have a long column of times (cell contents= '9:00PM ) extracted
| from another application and I want to subtract another time from them. Is
| there an easy way to convert this into a time that excel can use?
|
| thanks
| Kazza

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

    software

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