Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date & Time
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date & Time
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. your date and time in A1: =INT(A1) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting text format of time/date into Excel time/date for subtr | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |