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
adudani's avatar
adudani
Memorable Member
3 years ago

hi Anonymous,

 

left click on the "ABC123"  

 

 

select duration (clock)

 

Please let me know if this resolves your question.

 

Appreciate a thumbs up if his is helpful.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    When I change my type to duration, the entire column errors

    • adudani's avatar
      adudani
      Memorable Member
      3 years ago

      Anonymous  try using the "Time" instead of duration.
      If you still get an error/ not the result that is required.

       

      then, use the use "Split Colum"-> "By Delimiter"-> "left-most delimeter" ->use space as the delimiter.
      you will get two columns, one with date and one with time along with AM/PM. in the time column, change the type and see if it is resolved.

       

      let me know

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Ok closer. The time is almost correct. If it says 12:04:54 the number I actually need is 04:54. however I don't get the option to split the column when the type is Time.