How can I convert time entered as text to hours and minutes in Excel?
For example, 14m 40s
.
Our report sends the information over in text format. When copying it into Excel, I am unable to convert it to hours and minutes without manually changing the format to each cell one by one.
I have tried formatting the cells but because there is a "m" and "s" listed in the cell it will not convert. I have tried Data → Text to columns, but came to a dead end.
When trying to issue our agent metrics and averages for the week, there is simply not enough time to manually enter in each one to the correct format.