Currently, the output is a text field that isn't consistent, instead it varies based on the content.
So I can have results of 17m 2s; 16m; 11m 52s; etc. which don't allow easy conversion to numbers/time in any way.
The ideal would be for them to be in 24 hour format, so for the above examples:
00:17:02; 00:16:00; 00:11:52
But even if we could just get to: 17m 02s; 16m 00s; 11m 52s would be an improvement 
This is a huge hassle to fix when trying to manipulate the data and in the end I'm stuck with manually updating and fixing them by eye (I am no Excel/GSheets macro expert).
Best answer by Aparna
View original