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

    Time Slot Analysis

    Aut.Mark Aut.Mark

      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:

      WORKHOURS = (EXIT_TIMESTAMP - ENTRY_TIMESTAMP )  *60*24



      My goal is to obtain the following  Time Slot Analysis :



      How can i reach my goal?


         Thanks all