Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

Please follow the step and make a try.

Ensure that the column is Date/Time type. Select the Funnel duration column and then select "Time Only".

Times are extracted.

 

                                                                                      

                                                                   

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.