AnsweredAssumed Answered

Attendance Record Question

Question asked by janet0211 on Jul 23, 2017
Latest reply on Jul 23, 2017 by 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

Outcomes