How to extract time and date
 

Hi All,

How to extract time and date from a date time value.
Ex : 2/2/2007 14:00 , i need the date and time in sepearte cells, how do i
go about doing it, please advice.

How to extract time and date
 

=int(a1)
will return the date (format it as a date)

=a1-int(a1)
or
=mod(a1,1)
will return the time (format it as a time)


Hemanth wrote:

Hi All,

How to extract time and date from a date time value.
Ex : 2/2/2007 14:00 , i need the date and time in sepearte cells, how do i
go about doing it, please advice.

--

Dave Peterson

How to extract time and date
 

If A1=Date & time

B1 =INT(A1) format as DATE
C1 =MOD(A1,1) format as TIME

"Hemanth" wrote:

Hi All,

How to extract time and date from a date time value.
Ex : 2/2/2007 14:00 , i need the date and time in sepearte cells, how do i
go about doing it, please advice.