SOLVED
Converting milliseconds to minutes and seconds
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
lanny_newville
7 - Meteor
‎03-13-2015
10:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Does anyone know how to convert milliseconds to minutes and seconds using the formula tool?
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
- Preparation
1 REPLY 1
Ned
Alteryx Alumni (Retired)
‎03-13-2015
10:32 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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_
