I have an excel sheet data of attendance. I have to group the data in state-wise and write it into a separate excel sheet state-wise respectively.
After writing the excel sheet the date strings are converted to the numeric value. Can anyone have an idea to change the format? If I manually change the format then it comes for the correct format.
MasterAttendance.xlsx (Existing Sheet)
After grouping the output will be,
StateWiseAttendance.xlsx (State-wise sheet will be created)
Output Expected :
I need check-in and check-out cell values look like the below format as in the master attendance sheet.
07/15/2019 08:31 AM
Please find the AttendanceReport.zip (21.1 KB). Can you help me to get the expected outputs?