Creating a running total for time

[sreekanthac]

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.

[atcodedog05]

Hi @sreekanthac 

Here is one way of doing it.

Workflow:

Hope this helps : )

[atcodedog05 · Accepted solution]

Hi @sreekanthac 

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

Workflow:

Hope this helps : )

[sreekanthac]

Thank you @atcodedog05 for the quick response.