When I download to an Excel a Time Activities by Employee Detail or Time Activities by Client Report using the modern view it doesn't sum the hours but instance?

I appreciate you sharing the details when downloading the Time Activities by Employee Detail or Time Activities by Client report in Excel, @rewena.

In QuickBooks Online (QBO), to display the sum of hours for your employees, make sure to include the Duration column before exporting. This column reflects the total hours worked for your employees.

See the image below for reference:

Once exported to Excel, the report will show the duration values. However, when using a pivot table, it's important to select the correct settings to reflect total hours rather than counting the number of days. I highly recommend reviewing your pivot table setup to ensure it's configured appropriately. You may also reach out to your Microsoft Office Specialist (MOS) Certified for further assistance.

If you have any other questions, feel free to click the Reply button.