What to be done???
Normalize the values with TO_NUMBER and TO_NCHAR, then concatenate them using the following formula:
CONCAT(CONCAT(‘Days: ‘,TO_NCHAR(FLOOR(TO_NUMBER(TO_NCHAR({timeelapsed}/24))))),
CONCAT(‘ Hours: ‘,TO_NCHAR(MOD(TO_NUMBER(TO_NCHAR({timeelapsed})),24))))
What would be the output???
String
