2 Replies Latest reply: Aug 18, 2016 9:44 AM by Aut.Mark Aut.Mark RSS

    Time Slot Analysis

      Hi community ,

      i have a new challenge in my script, and  i can't figure out the solution.



      I have a big table with  "work hours" . It's something like that:


      ID_WORKER            DATE                 ENTRY_TIMESTAMP            EXIT_TIMESTAMP         sum( WORKHOURS)

      000001               2016/08/15                        08.00                                  12.30                         4.5

      The last field (WORKHOURS)is obtained in the script with:


      My goal is to obtain the following  Time Slot Analysis :

      How can i reach my goal?

         Thanks all