Export Column To Excel Data Issue - Cannot Perform Calculations

I have a board built where people can enter their time manually. I click on the arrow for each column to export to Excel. The data exports, but it will not allow me to perform any calculations for the duration column. I do a SUM function, and it ends up a ZERO. Just doing a format cells and changing it to another format does not work. How is the data formatted on export?