Excel Skill

=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