use dingtalk report to come up with total worked hour using excel vba
Budget: $10 – $15 USD
I am looking for someone to help me use Dingtalk report to come up with total worked hour using Excel VBA. The main purpose of this report is to calculate total work hours based on the Dingtalk report. I am open to any format for the report, but I would prefer that the script for the VBA be automated.
There were some staff who did not use dingtalk to thumb in, therefore my colleague used punch cards to update in the punch time column., so the original record and daily record are not tally with punch time.
When this total worked hour go live, the raw data best is to get is from daily record? as got clock in and clock out data.. but for now my HOD wants to get the update from punch time column first.. any idea?
There were some staff who did not use dingtalk to thumb in, therefore my colleague used punch cards to update in the punch time column., so the original record and daily record are not tally with punch time.
When this total worked hour go live, the raw data best is to get is from daily record? as got clock in and clock out data.. but for now my HOD wants to get the update from punch time column first.. any idea?