3 Replies Latest reply on Mar 8, 2018 2:17 PM by Andrew Bickert

How to convert number of seconds to format mm:ss

Kelly C Mar 8, 2018 1:48 PM

Hi Everyone,

I've been trying to reformat my number from seconds to mm:ss, but when i custom format the number to mm:ss, the 90 seconds turns into 00:00. My goal outcome would be for it to look like 1:30 instead of 90 seconds. I'm wondering if the issue has to do with my initial calculation for ASA....

Please see attached workbook.

Thanks so much!!

ASA Master.twbx 95.0 KB

1. Re: How to convert number of seconds to format mm:ss

Andrew Bickert Mar 8, 2018 2:02 PM (in response to Kelly C)

Hi Kelly,

If you take your ASA value and divide it by 86400 it will convert it into the decimal time value. You can then click on format>pane>numbers, and type in "hh:mm:ss".

Andrew
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: How to convert number of seconds to format mm:ss

Kelly C Mar 8, 2018 2:15 PM (in response to Andrew Bickert)

Thanks so much Andrew! Did not know it was that simple.
Like Show 0 Likes(0)

Actions
3. Re: How to convert number of seconds to format mm:ss

Andrew Bickert Mar 8, 2018 2:17 PM (in response to Kelly C)

No Problem, just an FYI, the reason for the 86400 is that is the amount of seconds in a day (24 hours x 60 minutes x 60 seconds).

Andrew
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

How to convert number of seconds to format mm:ss

1. Re: How to convert number of seconds to format mm:ss

2. Re: How to convert number of seconds to format mm:ss

3. Re: How to convert number of seconds to format mm:ss

Actions

More Like This