Forum Discussion

Icon for Resolver I rank

Resolver 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...

Dallas7890
4 years ago
Thank you so much, Vijay. The formula worked perfectly

Icon for Most Valuable Professional rank

Most Valuable Professional

4 years ago

Use below formula for minutes calculation

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

Dallas7890
Resolver 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
  Most 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
  - Dallas7890
    Resolver I
    4 years ago
    Hi Vijay,
    
    This formula works perfectly except for some really do end on the same day
    
    Is there any way to tell the formula that?
    
    Here is what it looks like now using your amazing formula
    The only problem if you see some are really starting at 6:30 am and ending on the same day shift at 4:30 pm
    
    Thank again for helping me with this.
    Much appreciated.

Related content