This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
1. I used a select tool first to extract just the 'Chat Time' Column. 2. Parsed Chat time through three DateTime tool to extract three field from Chat Time for Hours, Minutes and Seconds. 3. Joined using join multiple so I could use the Hours, Minutes and Seconds with one Formula Tool. 4. On the formula tool used Formula: IF LEFT([Hour],1)=='0' THEN RIGHT([Hour],1) ELSE [Hour] ENDIF on the Hour, Minutes and Seconds field while substituting the Hours with Minutes and Seconds on subsequent formula to remove leading '0'. 5. Used another set of 3 formula's on a new Field name mew Chat Time: IF [Hour]=="0" THEN "" ELSE [Hour] + " Hours " ENDIF. Same formula used again for minutes and seconds. 6. Use Select tool to display only the Chat Time and New Chat Time fields.