Forum Discussion
Duration import from Excel incorrect
I set my column in Excel to hh:mm:ss, but when it imported into Power BI it is 12/31/1899 12:00:00AM. What's the magic step to get my minutes and seconds back in my Power BI query editor? I'm a new ...
Ok I'm getting clsoer, thanks for the patience. But I cannot get the Index and the Range that I want.
I see this 12:00:00 AM and I just want the 00:00. I thought it would be 3 and 5 but that returned 00 AM. Any advice?