Export Hours Report with "0's" instead of dashes | Community
Skip to main content
September 12, 2019
New

Export Hours Report with "0's" instead of dashes

  • September 12, 2019
  • 0 replies
  • 218 views

When hours report are exported to excel, and there's no hours in a category it's represented on the report with a dash ( - ). Excel is unable to perform calculations when fields are blank. I manually replace all the dashes with 0's so the calculations can be done.