Forum Discussion
Power Query automatically converting total hours into datetime format, hence Tot_Hrs are incorrect
I have data with total hours column but when i'm importing the data into power query automatically getting converted to datetime format and getting the sum of hours incorrect. Although I have disabl...
Yes, but look at your 120:30:00 value in excel. It looks like it's still a date time in Excel, but just formatted as HHH:mm:ss. You need to either apply each Duration.TotalHours(Duration.From(Number.From([Name of your tm(Hrs) column, however you escape it]))).
But even easier to just make it text in Excel, then bring it in as text.
Power Query is importing the underlying value in the cell, regardless of how it's represented in the cell.
--Nate