Formatting and Displaying Time in Zoho Analytics

Formatting and Displaying Time in Zoho Analytics

How do I format a column in my data set to correctly display time or duration?

I import the data every day from an external Excel spreadsheet, and the format in the Excel sheet is "hh:mm:ss" but when I import it into Analytics it's formatted as "dd mmm yyyy hh:mm:ss".

I'm trying to create a dashboard using telephony data and I need to display the average talk time, but I'm struggling to do that with the whole formatting thing. Any help would be appreciated.