Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
I have time column with hh:mm data, however during analysis few plots show axis in seconds and few in hh:mm. How JMP decides what to use/display and how do I ensure output with consistent format?