2 Replies Latest reply: Jul 6, 2009 5:15 PM by Pär Erlandsson RSS

    Workinghours - How to do this ?

    Pär Erlandsson

      Hi !

      I have the following raw data:

      EmployeeNumberEmployeeNameTypeCodeTimeStartTimeEnd
      158Donald DuckBreak109:0009:15
      158Donald DuckBreak2
      158Donald DuckLunch12:0013:00
      158Donald DuckWorkingHours07:0016:00

      and I want this result

      EmployeeNumberEmployeeNameTotalWorkTime
      158Donald Duck07:45

      TotalWorkTime is Workinghours minus Lunch minus Break1&2

      Any ideas ?

      I attach a sample.

      /Pär