which method should I use RRS feed

  • Question

  • Hello

    I have found a solution to this but I do not think it is good enough and wondered if anyone could come up with good advice on this matter.

    I have a table like this:

    Date Name Hour
    01.10.2019 Alf 2,5
    01.10.2019 Alf 5
    02.10.2019 Alf 1
    02.10.2019 Alf 1,5
    02.10.2019 Alf 5
    03.10.2019 Alf 3
    03.10.2019 Alf 4,5
    04.10.2019 Alf 7,5
    05.10.2019 Alf 5,5
    05.10.2019 Alf 2

    I want to use the pivot table so that I see the total number of hours per day and then create a formula where everything over 8 hours per day is overtime. then I want to define this as a new table to use in a data model.

    Saturday, October 12, 2019 10:32 AM

All replies