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.
An example of the data file is attached. The column in question is highlighted.C--Users-06596.GLOBAL-Desktop-16010.xlsx