Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Apr 4, 2023, 5:10 PM

Hi, I have a column (hms), that is formatted as hh:mm:ss for the length of a bike trip.When I look at the data in Tableau, it is showing as a timestamp. How can I keep the formatting?

When I use the data in Tableau, it is converted to a datetime format. 

I want to get the average of column "hms" for different attributes such as "member casual", "season", etc. all while keeping the format the data is already in. How can I do so? I have been reading here all day, but nothing seems to work.

Looking forward to some help!

Thanks!

final_data_capstone.csv
1 answer
  1. Don Wise (Tableau Community Ambassador)
    Dec 17, 2025, 10:59 PM

    Simplest route to take here is separate the date from the 'time' value: 

     

    SUM (FLOAT ( [Hms]) - INT([Hms]))|

    Simplest route to take here is separate the date from the 'time' value: SUM (FLOAT ( [Hms]) - INT([Hms]))| Then format as follows:

     

    Then format as follows:

    Screenshot 2025-12-17 at 2.55.03 PM.png

     

     

Write an answer...
0/9000