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

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

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.