8 Replies Latest reply on Nov 15, 2014 8:53 AM by Hrvoje Gabelica

# Convert from seconds to hh:mm:ss grand total

Hi everyone,

is there any way to convert from seconds to hh:mm:ss and make grand total. Made converting but it's in discrete format so you can't grand total it. Also Tableau reset the clock when dividing [Seconds]/86400.

Hrvoje

Message was edited by: Hrvoje Gabelica

• ###### 1. Re: Convert from seconds to hh:mm:ss grand total

Hrvoje:

Check this blog post by Jonathan Drummey that explains how to solve it. Hope this helps.

..kk

• ###### 2. Re: Convert from seconds to hh:mm:ss grand total

It doesn't help me. Values in panes are bigger than the grand total

• ###### 3. Re: Convert from seconds to hh:mm:ss grand total

I don't think KK actually included the link, so I'm not sure what you mean when you say "It doesn't help me". He was probably going to link you to this 3 part series on Grand Totals, but I'm not sure:  http://drawingwithnumbers.artisart.org/customizing-grand-totals-part-1/

Can you please post an example TWBX so we can actually see the problem you're encountering?  Its very difficult to understand your problem without an example or some data to interact with.  Also, it is helpful to see what you've already attempted to do, so we can understand what you have tried and what has failed for you.

Cheers, and best of luck!

• ###### 4. Re: Convert from seconds to hh:mm:ss grand total

Thanks buddy Matt Lutton..don't know how I missed the link

..kk

• ###### 5. Re: Convert from seconds to hh:mm:ss grand total

It happens. We are all on the same team as far as I'm concerned so no worries!

• ###### 6. Re: Convert from seconds to hh:mm:ss grand total

Hi Matthew,

I converted seconds to hh:mm:ss format so when I want to sum, it doesn't sum right. Twbx is provided in attachment of the original post

Hrvoje

• ###### 7. Re: Convert from seconds to hh:mm:ss grand total

Hrvoje:

Don't know if this works, but I created two sheets with details in one and the grand total in the other. Using dashboard to put them together,..

As hh:mm:ss, resets after 24 hours, this is the best that I can come up with. Any other ideas Matt Lutton

..kk

• ###### 8. Re: Convert from seconds to hh:mm:ss grand total

Hi Karunaker,

it's not sophisticated one but it works, thanks for answer.

Hrvoje