date & Time

N

naresh vadlamudi

guys, i have date & time both as hte format below:

9/1/2012 07:45:00 AM. now i need to extract only date from it into another cell. please help.

regards,
naresh
 
C

Claus Busch

Hi,

Am Sat, 24 Nov 2012 01:57:55 -0800 (PST) schrieb naresh vadlamudi:
9/1/2012 07:45:00 AM. now i need to extract only date from it into another cell. please help.
Click to expand...

your date and time in A1:
=INT(A1)


Regards
Claus Busch
 

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

15 minute data to daily data 1
Extract Date formula Only 8
Countdown macro - display settings 2
End Date/Time adding business hours 1
reduce data points and average? 5
separating date and time 5
Countif between Time stamps and have - value 0
Help!!!! 0

Top