I'm hoping you can help me with my problem using importhtml with Google Sheets. It is a problem similar to Trying to use Google Sheets importHTML() to import a table. It forces content to a date format

I am using importhtml and query together to get data that includes duration data that can be in either XX:XX or XX:XX:XX. The data is not always HH:MM:SS format. Sometimes it's MM:SS:00 Sometimes it's MM:SS, and others are HH:MM:SS.

If I use importthtml and view the data while the the column is set to Automatic formatting, view of data is correct. However if I use query, in some cases the data changes to something weird, especially if the leading value is 24. 24 gets translated into 00. I guess it's getting confused with a time value. I would like either data to remain exactly as it comes from the URL, but it seems Google Sheets tries to format it. I've tried many different workarounds to no avail.

The table lookup is here.

=IMPORTHTML("http://www.thepowerof10.info/athletes/profile.aspx?athleteid=800922&viewby=date","table",18)

Time values are correct.

But if you use query in conjunction with importhtml, I get different values for only some of the results.

query(IMPORTHTML("http://www.thepowerof10.info/athletes/profile.aspx?athleteid=800922&viewby=date","table",18),"select Col1, Col2")

I hope that there is some way to get the data to be correct.

I'm hoping you can help me with my problem using importhtml with Google Sheets. It is a problem similar to Trying to use Google Sheets importHTML() to import a table. It forces content to a date format

I am using importhtml and query together to get data that includes duration data that can be in either XX:XX or XX:XX:XX. The data is not always HH:MM:SS format. Sometimes it's MM:SS:00 Sometimes it's MM:SS, and others are HH:MM:SS.

If I use importthtml and view the data while the the column is set to Automatic formatting, view of data is correct. However if I use query, in some cases the data changes to something weird, especially if the leading value is 24. 24 gets translated into 00. I guess it's getting confused with a time value. I would like either data to remain exactly as it comes from the URL, but it seems Google Sheets tries to format it. I've tried many different workarounds to no avail.

The table lookup with correct time values is:

=IMPORTHTML("http://www.thepowerof10.info/athletes/profile.aspx?athleteid=800922&viewby=date","table",18)

But using query in conjunction with importhtml I get different values for only some of the results.

=query(IMPORTHTML("http://www.thepowerof10.info/athletes/profile.aspx?athleteid=800922&viewby=date","table",18),"select Col1, Col2")

I hope that there is some way to get the data to be correct.