Grand Total of Time taken for activity on day to day

[SK01]

Hello,

I working on daily activity done by User on day to day basis and my ask is to calculate grand total of time taken and display on Tableau.

For this I need to convert time into number format then multiply by 60.

Please help with formula.

[cgoodman3 · Accepted solution]

Do you have a duration field in your data? If so you can break it down by using string functions:

For example if you have HH:mm:ss

Then create a new field in the formula tool called duration(mins) and then enter

tonumber(left([Time],2))*60+tonumber(substring([Time],3,2))+tonumber(right([Time],2)/60

Where [Time] is your time field and that will convert your time to minutes.

[RobertOdera]

Hi, @SK01 

Can you provide a little more context?

Given that you're looking for an output that will work nicely with Tableau (tall data format), it is helpful to understand:

1. time precision level (is the smallest unit hours, minutes, or seconds?) for your deisred formula

2. what is the input form that needs bending? (is it tabular, where you have User, Date, Start, Stop columns?)

With additional context (and perhaps a sample input file), the community will be able to give you solution/ mechanics that you can deploy.

Cheers!