Solved: Milliseconds column in csv to usable time value

data-tripper · 02-23-2025 05:24 AM

Hello,

Surprised at how such a simple problem seems to be so complex to solve. I have a csv a number column that stores millisecond data. What's the best way to get this to a usuable hh:mm:ss format in Looker Studio? I have tried calculated columns and custom number formats with no luck.

Thanks.

sam8

First, use a calculated field to convert the data from milliseconds to seconds. A simple (millis/1000) should work.

Second, click the field definition once it's in a table, and select the "Duration" data type. This expects a number of seconds, so the default format is fine.

View solution in original post

sam8

First, use a calculated field to convert the data from milliseconds to seconds. A simple (millis/1000) should work.

Second, click the field definition once it's in a table, and select the "Duration" data type. This expects a number of seconds, so the default format is fine.

data-tripper

Ah! Thank you! Knew it would be simple. I'd been looking for 'Duration' in the Date/Time menu but there it is under 'Number'. 😁