Forum Discussion

Gokul_G16's avatar
Gokul_G16
Icon for Resolver I rankResolver I
3 years ago

Greater than 24 Hrs Time format error data sources Excel into Power BI

Hi Connections / Arul  Thennarasu_R  amitchandak 

Since have been facing the time fornat while i'm imported Excel Scources into power BI, When ever the data feed as showcasing the More than 24 hrs. As following steps so for,

1. Excel file time As "25:35:50" just imported to Power BI it shown in "01:35:50" - once grossed the more than 24 hrs the data will conside in power from begning th time..
2. As per my scinorio daye wise some employee would having the one more than 24 hrs , Why because the data was coming based the user login details...

Following snap for your reference :

 

Once data was loaded into Power BI time is shown in from the beging ( Have tried the Text data type and time format also yet to be the same time which is having in excel input)



Excel sources  this is i wan to see in Powe BI as per the same values in Power Bi.


Friends,

Kindly suggest your valubale thoughts over here. How to show the more 24hrs values into same as value should be in Powe BI ..

Thanks in Advance,
Gokul

 

data protection
General Comment
Need Help
Show and Tell

4 Replies

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User
    3 years ago

    Gokul_G16 ,

    Can you just share the sample data with some dummy numbers (format should be same as your excel source)?
    Also, let us know the below,

    1. What is the actual requirement out of this column?

    2. Are you going to use this column anywhere in the calculation? If yes, what is the expected output of the calculation?

    Thanks,

    Arul

    • Gokul_G16's avatar
      Gokul_G16
      Icon for Resolver I rankResolver I
      3 years ago

      Hi Arul amitchandak ,

      Please find the data format for your reference,

      1. Yes, I want to explore the average's Logged Hrs per user wise once the complete 30 days over then will take month wise how hrs the ID would have.
      2. As here following data base, I should we explore in Table or Matrix visual. I'm expecting What is my sources i'm attaching here smae wnat o see in POwer BI data set post imported.

       

       

      User
      date
      ID
      Tot. Logged Hours
      Gokul
      29 May 2023
      1000780
      24:12:00
      Prakash
      17 May 2023
      34932
      26:56:00
      Arul
      30 May 2023
      34932
      24:36:00
      Kannan
      23 May 2023
      20588
      25:07:00
      a
      12 May 2023
      1092579
      24:08:00
      b
      16 May 2023
      1078407
      25:25:00
      c
      25 May 2023
      1078407
      24:05:00
      d
      26 May 2023
      1078407
      24:10:00
      Anu
      29 May 2023
      1078407
      24:25:00
      Aravind
      11 May 2023
      1078818
      24:33:00


      Thanks,
      Gokul