Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Allen01
New Member

Calculating Working Hours calculate from Time Colums

Hi, I'm new in power bi

 

I'm trying to calcualate engineer total working hours from End Time - Start Time.

When I use in query in Excel I can use End Time - Strat Time with substract (Duration). When I present chart format I just need to add Total Working Hrs Cloums to Value field and my sum time is display. 

 

But when I use in power bi duration data is not show as [hh]:mm format. 

I would like to get idea 

1) Duration to [hh]:mm Format (That can sum in value field)

2) End Time - Start Time = Time Format ( That can sum in value field) 

 

I would like to show as below chart table (Total support Ticket Number & Total working Hours) 

 

Allen01_0-1667038472820.png

Allen01_1-1667038495014.png

 

query chart 

Allen01_2-1667038643819.png

 

 

I already try from below link but not yet work for me. Please kindly help me for some solution. 

https://www.mssqltips.com/sqlservertip/7061/calculate-date-difference-power-bi-dax-datediff/

https://powerusers.microsoft.com/t5/Power-Query/Converting-Decimal-Hour-to-HH-MM-Format/m-p/1377637#...

https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/m-p/367362#M109 (use dayhoursminute) 

 

2 REPLIES 2
Allen01
New Member

@Anonymous 

Thank you for your solution. But when I try 

(1) Total working hour = format([end time] - [start time],"hh:mm:ss")

it's show the time that I want but when i use this column in the report values field it's count not show as sum. 

 

When i add new column and use this formula 

(2) sum of time = FORMAT(SUMX(Allen,Allen[End Time] - Allen[Start Time]),"HH:MM:SS")

it's show diffrent time then actual working hours. 

 

Maybe I'm doing wrong. Can you explain to me in the power bi i need to use new column for (1) and (2) or (2) is measure of cloumn (1) ? 

Thank you for your help. 

Anonymous
Not applicable

Hello could you please try 

Total working hour = format([end time] - [start time],"hh:mm:ss")

 

Screenshot 2022-10-29 143056.png

 and to find the sum use:

sum of time = FORMAT(SUMX(Allen,Allen[End Time] - Allen[Start Time]),"HH:MM:SS")

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.