Converting milliseconds to minutes and seconds

[lanny_newville]

Does anyone know how to convert milliseconds to minutes and seconds using the formula tool?

[Ned · Accepted solution]

Milliseconds are 1/1000th of a second.  So:

Minutes = Floor([ms]/1000/60)

Seconds = Mod([ms],1000*60)/1000

The help for the math functions can be found here:
http://help.alteryx.com/current/index.htm#Reference/Functions.htm#Math_