Floating Decimal to seconds calculator

JamesHartigan
JamesHartigan ⚪️
edited January 4 in Beastmode & Analytics
https://imgur.com/a/oFQPz7R

Hello,

I have a data set that is pulling in average time for an action but it is listed as a floating decimal *picture attached*

What I need to happen is convert this into MM:SS


The formula steps would normally be:

  1. Divide by 60
  2. Take decimal remainder and multiply that by 60
  3. Add the 2 numbers together


Is there a beastmode or way to transform this in the ETL?


Thanks

Tagged:

Categories