Forum Discussion

Dallas7890's avatar
Dallas7890
Icon for Resolver I rankResolver I
4 years ago
Solved

Display time over 24 hours in Power BI

Hello   I'm having a little challenge in a simple table trying to calculate the time passed, for example from 22:00 to 2:00 in the morning.   I have tried this code to calculate the Duration in M...
Need Help
  • Dallas7890's avatar
    Dallas7890
    4 years ago

    Thank you so much, Vijay. The formula worked perfectly

Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Use below formula for minutes calculation

Duration in Mintes = ([Shift end Date]-[Shift start Date])*1440

 

Dallas7890's avatar
Dallas7890
Icon for Resolver I rankResolver I
4 years ago

Hello Vijay,

 

Thanks for the formula but 

It's still the same problem when the time bleeds over past 12 am into the next day

I would also like to create a new date time that correctly shows the next day for these records. I just merged the date and the end date because I didn't now how to create and end date column and time column any other way.