2 Replies Latest reply on Jul 23, 2017 8:01 PM by janet0211

    Attendance Record Question

    janet0211

      Please help to change the list format for time calculation.

      (Calculating the time for same ID & same Date)

       

      Thanks for your help!!!!

       

      <Attendance Data>

      ID    Attendance Time

      0066    2017-02-01 07:15

      0007    2017-02-01 07:17

      0014    2017-02-01 07:17

      0041    2017-02-01 07:20

      0022    2017-02-01 07:23

      0044    2017-02-01 07:23

      0049    2017-02-01 07:23

      0021    2017-02-01 07:24

      0029    2017-02-01 07:26

      0065    2017-02-01 07:27

      0003    2017-02-01 07:28

      0008    2017-02-01 07:28

      0039    2017-02-01 07:28

      0053    2017-02-01 07:28

      0050    2017-02-01 07:28

      0005    2017-02-01 07:30

      ...

      ..

      .

       

      <Result>

      Generate list for calculating time

      ID    Date    Time1    Time2    Time3    Time4

      0003    2017-02-01    07:10    12:05    13:15    18:45

      0005    2017-02-01    07:15    12:15    13:25    18:15