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

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. 

 

 

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

The shift can't end before the shift starts. This issue will lead to data inconsistency.

Assuming the intention to put this data is correct, then you can use below formula

=ABS([Shift start Date]-[Shift end Date])*1440