<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Remove the string &amp;quot;Hours&amp;quot; when creating a report.. in Workfront Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/remove-the-string-quot-hours-quot-when-creating-a-report/m-p/539123#M49016</link>
    <description>&lt;P&gt;&lt;LI-USER uid="17429993"&gt;&lt;/LI-USER&gt;&amp;nbsp;- I've tried using this code in an assignment report and it doesn't seem to work. Wondering if it needs to be modified for this type of report. Do you have any suggestions? I tried adding task in front of actualWorkRequired and that didn't seem to pull anything. Thanks for any help you can provide.&lt;/P&gt;</description>
    <pubDate>Wed, 03 Aug 2022 16:41:48 GMT</pubDate>
    <dc:creator>KellieGardner</dc:creator>
    <dc:date>2022-08-03T16:41:48Z</dc:date>
    <item>
      <title>Remove the string "Hours" when creating a report..</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/remove-the-string-quot-hours-quot-when-creating-a-report/m-p/516351#M47593</link>
      <description>&lt;P&gt;Does anyone know how to drop the Hours string that gets added to Actual Hours when creating a report?  i.e.  10 Hours.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I have a report that has the actual hours, planned hours, and estimate at completion.   I export this to an Excel spreadsheet where I do comparisons to find tasks/projects that are in trouble.  I am tired of having to run the macro that does a find/replace to remove the "Hours" string from the worksheet so my Excel calculations function correctly.   I do not understand why it even puts in the "Hours" string on every row since the column heading is Actual or Planned Hours.&lt;/P&gt;</description>
      <pubDate>Fri, 16 Apr 2021 14:39:31 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/remove-the-string-quot-hours-quot-when-creating-a-report/m-p/516351#M47593</guid>
      <dc:creator>ChrisMo3</dc:creator>
      <dc:date>2021-04-16T14:39:31Z</dc:date>
    </item>
    <item>
      <title>Re: Remove the string "Hours" when creating a report..</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/remove-the-string-quot-hours-quot-when-creating-a-report/m-p/516352#M47594</link>
      <description>&lt;P&gt;Hi Chris,&lt;/P&gt;&lt;P&gt;I took this to our customer support team and here's what they sent. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;The only way I could remove the “Hours” was to change the valueformat, but that then returns the value in minutes. So you have to set up an expression to take that into account and display as the hour value. It looks like it exports fine for me when I use this method.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;displayname=Actual&lt;/P&gt;&lt;P&gt;textmode=true&lt;/P&gt;&lt;P&gt;valueexpression=DIV({actualWorkRequired},60)&lt;/P&gt;&lt;P&gt;valueformat=HTML&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I hope this helps!&lt;/P&gt;&lt;P&gt;Kyna&lt;/P&gt;&lt;P&gt; &lt;/P&gt;</description>
      <pubDate>Tue, 20 Apr 2021 17:02:47 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/remove-the-string-quot-hours-quot-when-creating-a-report/m-p/516352#M47594</guid>
      <dc:creator>kynabaker16</dc:creator>
      <dc:date>2021-04-20T17:02:47Z</dc:date>
    </item>
    <item>
      <title>Re: Remove the string "Hours" when creating a report..</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/remove-the-string-quot-hours-quot-when-creating-a-report/m-p/516353#M47595</link>
      <description>&lt;P&gt;Thank you so much Kyna!   This did they job.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Chris&lt;/P&gt;</description>
      <pubDate>Wed, 21 Apr 2021 17:28:08 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/remove-the-string-quot-hours-quot-when-creating-a-report/m-p/516353#M47595</guid>
      <dc:creator>ChrisMo3</dc:creator>
      <dc:date>2021-04-21T17:28:08Z</dc:date>
    </item>
    <item>
      <title>Re: Remove the string "Hours" when creating a report..</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/remove-the-string-quot-hours-quot-when-creating-a-report/m-p/516354#M47596</link>
      <description>&lt;P&gt;You bet! Glad I had the right people to ask. &lt;img class="lia-deferred-image lia-image-emoji" src="https://experienceleaguecommunities.adobe.com/html/@31B4D6D7B3510763F3CBB2AAB7997408/emoticons/1f642.png" alt=":slightly_smiling_face:" title=":slightly_smiling_face:" /&gt; &lt;/P&gt;</description>
      <pubDate>Wed, 21 Apr 2021 18:21:53 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/remove-the-string-quot-hours-quot-when-creating-a-report/m-p/516354#M47596</guid>
      <dc:creator>kynabaker16</dc:creator>
      <dc:date>2021-04-21T18:21:53Z</dc:date>
    </item>
    <item>
      <title>Re: Remove the string "Hours" when creating a report..</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/remove-the-string-quot-hours-quot-when-creating-a-report/m-p/539123#M49016</link>
      <description>&lt;P&gt;&lt;LI-USER uid="17429993"&gt;&lt;/LI-USER&gt;&amp;nbsp;- I've tried using this code in an assignment report and it doesn't seem to work. Wondering if it needs to be modified for this type of report. Do you have any suggestions? I tried adding task in front of actualWorkRequired and that didn't seem to pull anything. Thanks for any help you can provide.&lt;/P&gt;</description>
      <pubDate>Wed, 03 Aug 2022 16:41:48 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/remove-the-string-quot-hours-quot-when-creating-a-report/m-p/539123#M49016</guid>
      <dc:creator>KellieGardner</dc:creator>
      <dc:date>2022-08-03T16:41:48Z</dc:date>
    </item>
  </channel>
</rss>

