Formula to convert Milliseconds to Days, Hours, Minutes and Seconds

Formula to convert Milliseconds to Days, Hours, Minutes and Seconds

When any time value is represented in milliseconds, it can be converted to human readable format as below.

1000000000 milliseconds can be converted to 11Days 13Hours 46Minutes 40Seconds. The column 'Time in MS' in the formula can be replaced with the respective time column.


Formula:
concat(floor("Time in MS"/(1000*60*60*24)),' days ',floor(Mod("Time in MS", 24*60*60*1000)/(60*60*1000)),' hours ',floor(mod(Mod("Time in MS", 24*60*60*1000),(60*60*1000))/(60*1000)),' minutes ',floor(Mod(mod(Mod("Time in MS", 24*60*60*1000),(60*60*1000)),(60*1000))/1000),' seconds')

Sample  Output:



                New to ADManager Plus?

                  New to ADSelfService Plus?

                    • Related Articles

                    • Formula createdtime() function throws error

                      Issue: When we create a formula column using the 'createdtime()' function, it throws unexpected error occurred. Analytics Plus Builds affected : 4300 & 4310 This is found as an issue within Analytics Plus and found happening on build 4300 and 4310. ...
                    • Make Change ID in Analytics Plus clickable - Hyper linking to SDP ticket

                      Requirement: To create a formula column in AnalyticsPlus for Change request as a 'URL' to respective ServiceDesk Plus Change request. Solution: Step 1: Open a Change request in ServiceDesk Plus and copy the URL in the address bar as shown below. ( ...
                    • Make Request ID in Analytics Plus clickable - Hyper linking to SDP ticket

                      Here are the steps to add a column with Request ID as link to SDP tikcet. Step 1: Open a request from ServiceDesk Plus and copy the URL as shown below,  ( http://localhost:9090/WorkOrder.do?woMode=viewWO&woID=) Step 2: Create a custom formula in ...
                    • How to remove unused AuthTokens?

                      There might be some rare situations where you have to remove unused AuthTokens from your Analytics Plus account. Please follow the steps below: 1. Launch Analytics Plus in a web-browser. The web address used to access the application is of the ...
                    • AnalyticsPlus Startup issue

                      Issue: Unable to start the services when there is a formula column created with static data Cause: When a formula column holds static data static data (like 123 or 1*24)  then those data types are stored as INT4 or INT8 or float8 because which the ...