Hi Experts,
I have the raw data from the system which is not organize properly in the table. And those data is the time record whether the staff clock in and out. So I want to transform/create the table with calculation. In my attached file, I have 2 tables, which include "Table 1" is the raw data from the system while the "Table 2" is the result of the table after organizing. In the system will record the times that staff clock in and out, if staff clock in and out 4 to 6 time, then it will record/show the total number that they clock in/out. So in the table should record only when they report to work, off work, and break time (in and out).
Could u pls share if there is any possible way to get it done by excel formula or VBA.
And I am using both office 2019 and 2021.
Thank you!
I have the raw data from the system which is not organize properly in the table. And those data is the time record whether the staff clock in and out. So I want to transform/create the table with calculation. In my attached file, I have 2 tables, which include "Table 1" is the raw data from the system while the "Table 2" is the result of the table after organizing. In the system will record the times that staff clock in and out, if staff clock in and out 4 to 6 time, then it will record/show the total number that they clock in/out. So in the table should record only when they report to work, off work, and break time (in and out).
Could u pls share if there is any possible way to get it done by excel formula or VBA.
And I am using both office 2019 and 2021.
Thank you!