In my datatable at the following URL, the "Time" column indicates the duration of a swim: https://marathon-swims.com/staging/5887/australian-marathon-swim-races/full-database/

I the settings, I have this formatted as 24h Time. Unfortunately, for the swims where the duration exceeds 24h, nothing is displayed (e.g. row 3).

I am using a Google Spreadsheet connector, and the duration appears properly formatted in the original spreadsheet (using custom time format of [hh]:mm:ss - the brackets allow for times above 24h).

Is there any workaround you can suggest, such as using a custom js script to manage these cases?

Thanks