度分秒计算(外国英语资料).docVIP

度分秒计算One minute and second degree value conversion degreeFirst of all to the unit symbols are removed, the formation of 1112233 forms, less than ten minutes to fill 0 before, must be, otherwise unable to determine the location of minutes and seconds.Suppose the raw data is in the A column, and the first data is in the A2 cell.In a cell where you need to put the conversion result (preferably with the same line as A2, so that a lot of raw data is converted, you can convert all the data directly from the drop down):=value (IF (LEN (A2) =6, CONCATENATE (A2), A2), 1,3)) +value (MID (IF (LEN), =6, C