How to extract time and date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date / Time Filter 2
How do I extract time only in Excel? 6
how to auto extract item# upon entering a date 9
Extracting specific data from Date and time strings 3
Access General Date Forced To Have Date And Time 2
date & Time 1
COUNTIF doesn't work 12
Converting a non recognizable date time 1

Back
Top