cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Convert time hour to minutes

 

 

Hello, I’m trying to find a way to convert time hour to minutes, so the data output is showing in minutes 

for Example, 01:10:00 (HH:MM: SS) should see 70

1 ACCEPTED SOLUTION

Thank you very much that really help  Smiley Happy

View solution in original post

2 REPLIES 2
Microsoft
Microsoft

Hi @yairzafrany,

 

Based on my test, you should be able to use the formula(DAX) below to create a new calculate column in your table to convert the time to minutes. Smiley Happy

Column = HOUR(Table1[Column1])*60+MINUTE(Table1[Column1])

Note: You'll need to replace Table1[Column1] with your real table name and column name.

 

c1.PNG

 

Regards

Thank you very much that really help  Smiley Happy

View solution in original post

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors