Path's Time to Next Step - in seconds
I'm looking to understand the distribution of how long it takes users to move from one page view to the next page view. With a Path report, I can set this up and export the csv with Time to Next Step. However, in excel the Time to Next Step is a text string of either XXm XXs, XXs, or XXms. Does anyone have a ready to use excel formula I can use to convert this field to all seconds (or ms), so that I can create a chart that illustrates the distribution of time to next step using all the same unit of time measurement?