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?
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Export data to excel without formatting? | 3 | 2670 | August 26, 2021 | |
| Export to Excel - issue with dates from formula column | 2 | 3580 | June 21, 2021 | |
| Why do some columns not export properly to Excel? | 1 | 3387 | April 16, 2022 | |
| Export to Excel | 5 | 2245 | August 18, 2022 | |
| Export to Excel - Fails or Times Out | 0 | 1746 | October 26, 2022 |