How to convert Time/Text format to Hours format

Options

Hello Everyone! I am trying to find out how to convert a time/text format to an hours format. I have tried reaching out to the data source and they can't modify the formatting. Also this is a monthly data pull so I could manually edit prior to uploading to Smartsheets however was trying to prevent from having to do that. Any help would be greatly appreciated!


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!