Hi, I want to import a file from excel that contains a duration column in the format HH:MM:SS.
What would be the best column type to use and I presume I would need a formula to turn the result into something I could then sum in a chart?
Thanks
Hi Richard!
Currently, the excel import function supports the following column types: Number, Status, Email, Date, or Text column.
With this in mind, if your duration column in excel is pulling from two dates. You will need to import that data into two Date Columns and then add a Formula Column and build the formula within the board instead of importing it. Hope this helps!