=IF(O2="MIN",ROUND(M2/60,3),IF(O2="S",ROUND(M2/3600,2),M2))
=IF(H2="MIN",ROUND(F2/60,3),IF(H2="S",ROUND(F2/3600,2),F2))
=IF(P2="MIN",RRUND(N2/60,3),IF(P2="H",N2,""))
>>>>>>>>>>>>>>>>>>>>>Determine the std and non-std parts <<<<<<<<<<<<<<<<<<<<<<<<<<
‘= IF(OR(LEFT(C2,3)={"HY6";"HY5";"HY7";"HY8"}),LEFT(C2,3),IF(RIGHT(C2,1)="R",RIGHT(C2,1),RIGHT(C2,2)))
=VLOOKUP( IF(OR(LEFT(C2,3)={"HY6";"HY5";"HY7";"HY8"}),LEFT(C2,3),IF(RIGHT(C2,1)="R",RIGHT(C2,1),RIGHT(C2,2))),A:B,2,0)
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
ER Custom
FR Custom
ED Custom
FD Custom
R1 Custom
R Custom
HY5 Custom
HY6 Custom
HY7 Custom
HY8 Custom
SP Custom
原文：http://www.cnblogs.com/jefflu2012/p/4013366.html