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!
