How to extract time and date

H

Hemanth

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.
 
D

Dave Peterson

=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)
 
Top