| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting text format of time/date into Excel time/date for subtr
=DATEVALUE(LEFT(A1,FIND(" ",A1)-1))+TIMEVALUE(MID(A1,FIND(" ",A1)+1,256))
-- Gary''s Student - gsnu201001 "YY san." wrote: Hi, I need some help on date. I have the date and time in text format. 13/01/2010 10:34 AM 13/01/2010 1:56 PM I need a formula to convert them to excel date/time format so that I can do subtraction between these dates. Thank you very much, YY |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help converting text to date & time? | Excel Worksheet Functions | |||
| Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| converting general text to date time | Excel Discussion (Misc queries) | |||
| converting text in cell to a date time | Excel Worksheet Functions | |||
Hybrid Mode
