Forum Discussion

bhmiller89's avatar
bhmiller89
Icon for Helper V rankHelper V
8 years ago
Solved

Duration Calculation across days

I have a data set that shows Job Report Dates.    I want to calculate basically someone's shift. For the EndofShift I used the Max Job Report Date/Time and then for the BeginningofShift I used the ...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    bhmiller89

     

    You can just have the EndTime subtract StartTime. The result is calculated in days. To get hours, just multiply by 24.

     

     

    You can also do it with Power Query. 

     

     

    Or you can write an expression like: 

     

    =Duration.Hours(Duration.From([EndTime]-[StartTime]))

     

    Regards,

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Can you provide some sample data? Specifically, is it a Date/Time column that has the date and the time? What interval are you using for your DATEDIFF?