Please help!   I export reports each week to pull hours (duration) by employee.   the duration column has ALWAYS been formatted as a decimal (40.00) so they can be added up, averaged, etc.   Today, as I'm trying to pull my reports in, the duration column is coming in as TEXT (40:00) which I can't use formulas with. Please help!  I have tons of reports that I do every Thursday night and now I'm freaking out!

Attached a file to show the difference. I need it back to the old format for formulas to work!