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,

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
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,

Deaviouspeanut's avatar
Deaviouspeanut
Regular Visitor
2 years ago

With the duration.hours, How do I make it not respond -16 when the hours are 4pm to 12am which should be 8