How to convert Time/Text format to Hours format
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!
Help Article Resources
Check out the Formula Handbook template!