I am going to prepare monthly attendance sheet based on the data that collected by google forms. My raw data's header is :
Employee Name & ID: Designation: Working Address: Attendance Type: Date Time
AAA (001) Support Staff Kolkata, India Time In 15/04/2021 08:21:16
BBB (002) Support Staff Kolkata, India Time In 15/04/2021 08:21:43
CCC (003) Support Staff Kolkata, India Time In 15/04/2021 08:37:35
DDD (004) Support Staff Kolkata, India Time In 15/04/2021 08:41:14
EEE (005) Support Staff Kolkata, India Time In 15/04/2021 08:43:16
AAA (001) Support Staff Kolkata, India Time Out 15/04/2021 17:30:20
BBB (002) Support Staff Kolkata, India Time Out 15/04/2021 17:15:10
CCC (003) Support Staff Kolkata, India Time Out 15/04/2021 17:00:50
DDD (004) Support Staff Kolkata, India Time Out 15/04/2021 17:01:25
EEE (005) Support Staff Kolkata, India Time Out 15/04/2021 17:10:20
FFF (006) Support Staff Kolkata, India Time In 16/04/2021 08:41:14
FFF (006) Support Staff Kolkata, India Time Out 16/04/2021 18:10:01
I wan to generate the monthly attendance sheet like below:
Employee Name & ID: Designation: Working Address: 15/04/2021 16/04/2021
Time In Time Out Total Hour Time In Time Out Total Hour
AAA (001) Support Staff Kolkata, India 08:21:16 17:30:20 09:09 N N N
BBB (002) Support Staff Kolkata, India 08:21:43 17:15:10 08:53 N N N
CCC (003) Support Staff Kolkata, India 08:37:35 17:00:50 08:23 N N N
DDD (004) Support Staff Kolkata, India 08:41:14 17:01:25 08:20 N N N
EEE (005) Support Staff Kolkata, India 08:43:16 17:10:20 08:27 N N N
FFF (006) Support Staff Kolkata, India N N N 08:41:14 18:10:01 09:28
For more information, please see the attachment.
Bookmarks