Calculate Time over multiple months

Bassehave ,

Its not that simple 🙂

You can do it in number of steps.

1. Change your time column to text format. So it will look like normal time format but its text 00:04:00 
2. Split by delimiter :
3. You will have 3 columns (One for HOURS, second is MINUTES and third is SECONDS) change type to WHOLE NUMBER
4. From Add Column tab select CUSTOM COLUMN, name this column CustomH 
   1. HOURS * 3600 (thats number of seconds in one hour)
5. From Add Column tab select CUSTOM COLUMN, name this column CustomM
   1. MINUTES * 60 (number of seconds in one minute)
6. From Add Column tab select CUSTOM COLUMN, name this column TimeInSeconds
   
   1. CustomH + CustomM + SECONDS
7. Close & Apply

Now you converted your time into seconds =D

Then create new measure and copy and paste my logic but just use your table name and column name.

Hope it clear now.

Abduvali