Forum Discussion

mik618's avatar
mik618
Icon for Helper I rankHelper I
6 years ago
Solved

Measure to calculate time worked

Hi There,    I'm looking to try and calculate a measure to show how mant hours & Minutes a staff member worked per day.    Staff work on appointments that have a start date and time, and an end d...
Need Help
jstorm's avatar
jstorm
Icon for Resolver III rankResolver III
6 years ago

You could use a CALCULATE function with MIN() and MAX() to determine start and end times for the employee's day then simply find the difference.

EX.

CALCULATE(
    MAX( [End] ) -

    MIN( [Start] ),

    [Filter1]

)

  • mik618's avatar
    mik618
    Icon for Helper I rankHelper I
    6 years ago

    HI jstorm 

     

    Thanks, but the problem with that is that there are gaps in the day where the staff won't be wokring and I don't want to include this time