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.