Importhtml() on google sheet converted data to a different format

[Abdmujib]

I have sport data that I imported from an api

There is a particular column named G in which, two data are combined and partitioned with a colon ( : ) (attached is the pic)

So when the column is imported into the sheet, it changes format to hh:mm:ss (time format) e.g 56:45:00.

Kindly check the 2nd row of the column, the initial data was 106:65, but the imported record has been round up to 107:05:00. For every number greater than 60, it is converted in to 1 min and added it to the hh.

For the table that has not entered 100, i.e 93:90 won't be converted to hh:mm:ss format, i believe it will be mm:ss.

That's what is challenging for me, so that's why I need a solution to importhtml function to bring exact data

Please kindly provide a way around it. Thanks
pls kindly help, I have be stucked here for days.

Thanks

 

[Fluff]

Duplicate to: Importhtml on google sheet converted data to a different format

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.

Also please do not tag members in your posts.