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 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. ( ...Query to Fetch Inactive Columns from a Workspace
Requirement: Customer wanted to determine the number of used or unused columns in a workspace. Solution: To achieve this, we need to connect to the Analytics Plus database by using local database import method (PostgrSQL) and then use the custom ...Sync issue between SDP MSP and Aplus
Issue: Sync fails between ServiceDesk Plus MSP and AnalyticsPlus, after upgrading the SDP to 14730. Cause: An example of a case mismatch issue is when Analytics Plus seeks column alias names such as BillID, but MSP returns BILLID instead. This is a ...Creating .keystore and .csr for generating new SSL certificate
Import third party SSL Certificate in ManageEngine Analytics Plus In order to implement SSL, a web server must have an associated certificate for each external interface (IP address) that accepts secure connections. Procedure for creating a csr - ...