Attendance Calculation Problem

Document created by janet0211 on Jul 20, 2017
Version 1Show Document
  • View in full screen mode

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

...

..

.

 

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

Attachments

    Outcomes