Values time duration not coming correctly

[Nazeem81]

i,

I have an excel file with time duration date per sales person, but when I import the excelfile to power BI and change the time duration to data type time, the values for time duration between the data in Excel and Power BI do not always match. See example below, In Excel it shows 0:00:51 but in Power BI 00:00:50, why is that?

From Excel

From Power BI

[v-yulgu-msft]

Hi @Nazeem81,

In my test, the time value is not changed after loading into Power BI desktop.

In your scenario, please check whether the data coming is correct in Query Editor mode. I think the wrong time duration displayed in visual is returned by your formula.

Below is my test, please have a look at.

Duration = HOUR ( Test5[Time] )&":"&MINUTE(Test5[Time])&":"&SECOND(Test5[Time])

Best regards,

Yuliana Gu

[Nazeem81]

HI @v-yulgu-msft,

I noticed that in the query editor the time duration is with decimals.  See picture below. When I use my calculated measure in the report view the value is not coming correct due to the decimal issue. How can I solve this?

[Nazeem81]

Anyone please?

[Nazeem81]

I have added a link to the excel file im using (http://www.filedropper.com/januaritidrapport). Im trying to summarize the the column "Overksam tid" by using the forrmula below, but as mentioned in previous mail it's not coming correct in Power BI.

Sum Overksam tid = VAR TotalSeconds = SUMX ( 'Tiddata'; HOUR ( 'Tiddata'[Overksam tid] )
* 3600 + MINUTE ( 'Tiddata'[Overksam tid] ) * 60 + SECOND
( 'Tiddata'[Overksam tid] ) ) VAR Hors = TRUNC
( TotalSeconds / 3600 ) VAR Mins = TRUNC
( MOD ( TotalSeconds; 3600 ) / 60 )
VAR Secs = MOD ( TotalSeconds; 60 )
RETURN IF ( Hors < 10; "0" & Hors; Hors )
& ":" & IF ( Mins < 10; "0" & Mins; Mins ) & ":" & IF ( Secs < 10; "0" & Secs; Secs )