This occurs when working with a QuickBooks List report that contains user defined fields as a row in Microsoft(R) Excel. Defined fields don't respond to Excel formulas in exported list reports.
This can also occur with exported Time reports or reports where billable time are included. A time in QuickBooks reports may be displayed as a whole number, in Excel it will appear as ### : ## .
Intuit recommends 2 solutions for this problem. The first solution may solve your problem, or you may need to try all 3 to resolve the issue. For best results, perform the solutions in the order shown.
Solution 1: Export the report as a comma separated values (.csv) file:
Note: If it is necessary to have the file in .xls format, you can go to Save as in Excel and change the format.
Solution 2: Copy the worksheet to a new worksheet:
The formula should work on the new page. Although it may look like a problem in Excel, there is no clear definition why the formulas don't work within our imported regions. If you create a SUM formula outside the marked page breaks within the original worksheet, the formulas will work.