In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Creating a running total for time

sreekanthac
8 - Asteroid

Hello Community,

 

I am trying to create a running total for time. I have a table with a column having the time as shown in the pic. Time is stored as datatype Time. I am trying to create a running total for time. I understand that this cannot be achieved using the tool Runnig Total. Is there any alternative to this, a function similar to DateTimeDiff()?

 

Thank you in advance for your support.

 

sreekanthac_0-1642098990481.png

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @sreekanthac 

 

Here is one way of doing it.

 

Workflow:

atcodedog05_0-1642099447001.png

 

Hope this helps : )

 

atcodedog05
22 - Nova
22 - Nova

Hi @sreekanthac 

 

Here is method 2 which will let you show time more than 24hrs

 

Workflow:

atcodedog05_0-1642099948461.png

 

Hope this helps : )

 

sreekanthac
8 - Asteroid

Thank you @atcodedog05 for the quick response. 

Labels
Top Solution Authors