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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
malathi
New Member

Time to Seconds Conversion

Hi All Power BI Gurus,

I need help in calculating the difference in times in MM:SS format. I have two columns with times (Time1 and Time2) and I want the difference these two times in a new column (Time Diff). I'm very new to power BI and I'm learning dashboard. Please help me with this formating issue as well. I tried duration.totext and also DATEDIFF but I didn't get any results, it was giving me some syntax error. 

 

Time1      Time2        Time Diff
1:20:05    1:30:05       10:00
13:10:00  13:20:50     10:30

 

Thank you,

M

0 REPLIES 0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors