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

Here is a better look. For example, some really do start and end on the same shift 

 

for example the start at 7:00:00 AM should still end on the same day 4/1/2021 at 8:00:00pm

 

also the 12:00 AM to 12:00: AM should all just remain as the same day

No time was really worked on these days

 

 

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

Replacing End Date time with this formula will solve the problem

if [End]>=[Start] then [Date]&[End] else Date.AddDays([Date],1)&[End]