Calculated Column - Overtime Hours Weekly & Daily

HI EnochS

The following calculated column gets close to your first requirement.  The problem is, we need another column to split the shigts  where the user has two entries on the same day.  This is to allow you to identify the shift where you step into overtime.

If you don't have another ID column, perhaps add an index column in the query editor.  Let me know if you need help with this

Cumulative Hours for week = 
    SUMX(
        FILTER(
            'Table3',
            'Table3'[User ID] = EARLIER('Table3'[User ID]) &&
            Table3[Week #] = EARLIER('Table3'[Week #]) &&
            'Table3'[Date] <= EARLIER('Table3'[Date])
            ),
            'Table3'[Hours])

Hi EnochS

If you use the "Add an index" feature in the Query Editory (becareful to sort your data first!)

Then you can add the column to the calculation.  I have shown it here in bold

Cumulative Hours for week = 
    SUMX(
        FILTER(
            'Table3',
            'Table3'[User ID] = EARLIER('Table3'[User ID]) &&
            Table3[Week #] = EARLIER('Table3'[Week #]) &&
            'Table3'[Date] <= EARLIER('Table3'[Date]) &&
            'Table3'[Index] <= EARLIER('Table3'[Index])
            ),
            'Table3'[Hours])

The cumulative hours column can now be split, with the last one used to drive your TRUE column and see how much overtime etc