---
title: "[Xporter] Convert milliseconds to duration (days, hours, minutes and seconds)"
canonical: "https://docs.getxray.app/space/ProductKB/46268683/%5BXporter%5D%20Convert%20milliseconds%20to%20duration%20(days%2C%20hours%2C%20minutes%20and%20seconds)"
format: markdown
---
# Problem 

Usually when exporting time duration information this comes in milliseconds. Here you will find a simple formula using javascript, to convert milliseconds into days, hours, minutes, and seconds.

# Solution

This follow notation has javascript embedded.

`%{var seconds = Math.floor(${MTRS} / 1000); `

`  var minute = Math.floor(seconds / 60); `

`  seconds = seconds % 60; `

`  var hour = Math.floor(minute / 60); `

`  minute = minute % 60; var day = Math.floor(hour / 24);`

`  hour = hour % 24; day + " days " + hour  + " hours " + minute + " minute " + seconds + " seconds"}`

# Link for related documentation

[Here](https://confluence.xpand-it.com/display/public/XPORTER/JavaScript) you will find information about using Javascript in Xporter.