I'm pulling reports from a Learning Management System on training completions. While my team is working on modifying the backend information to deliver consistent data, I still need to report on current data coming out. I have a column labeled "Training Duration". The data currently being delivered can be in either Minutes or Hours. An example of each is below:
I'd like to examine the cell and convert all of them to A) Hours and B) a cell with just the actual time listed. The above examples would then be turned into the following:
Is this a VB script problem? Is there some formula in Excel that would allow me to do this? Any assistance, suggestions or recommendations are appreciated.