Access 2010 Convert Date To Serial Number
Convert Date Nepali To EnglishAssuming the whole format is YYYYMMDDHHMM and that the first such value is in cell A1, you can use the following formula in B1: =DATEVALUE(MID(A1,7,2) & '/' & MID(A1,5,2) & '/' & MID(A1,1,4)) + TIMEVALUE(MID(A1,10,2) & ':' & MID(A1,12,2)) This creates a date serial number based on DD/MM/YYYY using the MID function to gather each part, and the DATEVALUE function to r..
더보기