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

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. 

 

adudani's avatar
adudani
Memorable Member
3 years ago

add / transform column -> extract (ABC123) -> range -> specify the starting index and charecters to extract.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Where do I type that?

    • adudani's avatar
      adudani
      Memorable Member
      3 years ago

      select range