Remove the string "Hours" when creating a report.. | Community
Skip to main content
Level 2
April 16, 2021
Solved

Remove the string "Hours" when creating a report..

  • April 16, 2021
  • 1 reply
  • 852 views

Does anyone know how to drop the Hours string that gets added to Actual Hours when creating a report? i.e. 10 Hours.

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by kynabaker16

Hi Chris,

I took this to our customer support team and here's what they sent.

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.

displayname=Actual

textmode=true

valueexpression=DIV({actualWorkRequired},60)

valueformat=HTML

I hope this helps!

Kyna

1 reply

kynabaker16
Adobe Employee
kynabaker16Adobe EmployeeAccepted solution
Adobe Employee
April 20, 2021

Hi Chris,

I took this to our customer support team and here's what they sent.

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.

displayname=Actual

textmode=true

valueexpression=DIV({actualWorkRequired},60)

valueformat=HTML

I hope this helps!

Kyna

ChrisMo3Author
Level 2
April 21, 2021

Thank you so much Kyna! This did they job.

Chris

kynabaker16
Adobe Employee
Adobe Employee
April 21, 2021

You bet! Glad I had the right people to ask. :)