When I pull the information for call duration for my department it puts it into excel as '1h 22m 59s' as text and I need to change it into a format excel recognizes for time. For example 01:22:59 or even total minutes could be useful. Some calls last less than an hour as well so if there is a formula that can convert both that would be great! I have also attached a short list of times if this helps.
Thank you
Bookmarks