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

[Gokul_G16]

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

[Arul]

@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]

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

[Arul]

@Gokul_G16 ,

Go through this thread and try to replicate the steps.
https://community.fabric.microsoft.com/t5/Desktop/PowerQuery-Duration-more-than-24-hours/td-p/267272

Thanks,

Arul

[Gokul_G16]

Hi @Arul ,

Thanks for forwarding, We should be convert time into seconds while we import Power BI, Then we can able to see the Time >24 hrs values in Power BI..

Try it this once you imported into data in Power BI in back end : 

Duration.TotalSeconds([MyData] - #datetime(1899,12,31,0,0,0))

Thanks,
Gokul