1
1
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.
Thank you so much!!! we have one other field with data that only provides the seconds (6s), how would the formula change? We have very few and far days in between where our hold time goes beyond a minute. – Tanisha – 2017-05-30T21:45:01.247
1@Tanisha See my EDIT#1 – Gary's Student – 2017-05-30T22:15:48.973