Nuacht

To fix DataFormat.Error, We couldn't convert to Number, when working with data in Power Query, whether in Excel or Power BI use these solutions ...
How to convert time values into decimal values in Excel Internally, Excel stores the time as a decimal value. The quickest way to see that time value is to change the format.