I want to split the date & time in one cell to be 2 colums; Date and another
colum is Time. i.e. 4/11/2006 14.30
How should I do?
I want to split the date & time in one cell to be 2 colums; Date and another
colum is Time. i.e. 4/11/2006 14.30
How should I do?
In A1: =TODAY()
format dd/mm/yyyy
in B1:
=NOW()-TODAY()
format hh:mm:ss
HTH
--
AP
"Aom" <[email protected]> a écrit dans le message de
news:[email protected]...
> I want to split the date & time in one cell to be 2 colums; Date and
another
> colum is Time. i.e. 4/11/2006 14.30
> How should I do?
If the entry is 4/11/2006 14:30 where time is 14:30 (not 14.30)...
B2:
=INT(A2)
C2:
=A2-B2
Format B2 as date and C2 as time.
Aom wrote:
> I want to split the date & time in one cell to be 2 colums; Date and another
> colum is Time. i.e. 4/11/2006 14.30
> How should I do?
=INT(A2)
and
=MOD(A2,1)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Aom" <[email protected]> wrote in message
news:[email protected]...
> I want to split the date & time in one cell to be 2 colums; Date and
another
> colum is Time. i.e. 4/11/2006 14.30
> How should I do?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks