Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help converting text to date & time?
Rec'd date/time data as: "12/01/08@12:05 PM". Does anyone have an easy way to
conver this to date-time data for calculation in Excel????? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help converting text to date & time?
Edit/ Find and Replace/ change @ to a space
or =--SUBSTITUTE(A1,"@"," ") and format appropriately, but in either case don't forget to tell your system (in Windows Regional Settings under Control Panel) whether you are working in dd/mm/yy or mm/dd/yy, as 12/01/08 is ambiguous. -- David Biddulph "Jon M" wrote in message ... Rec'd date/time data as: "12/01/08@12:05 PM". Does anyone have an easy way to conver this to date-time data for calculation in Excel????? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help converting text to date & time?
=DATEVALUE(LEFT(A7,8))+TIMEVALUE(RIGHT(A7,8))
Regards, Stefi €˛Jon M€¯ ezt Ć*rta: Rec'd date/time data as: "12/01/08@12:05 PM". Does anyone have an easy way to conver this to date-time data for calculation in Excel????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting a date to a text field w/o converting it to a julian da | Excel Worksheet Functions | |||
Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
Converting UTC timestamp value to date and time | Excel Discussion (Misc queries) | |||
converting general text to date time | Excel Discussion (Misc queries) | |||
converting text in cell to a date time | Excel Worksheet Functions |