we have a data feed that is downloaded direct from our finger scan for employee time keeping, however, we need this data converting to be used in our excel time sheets.
ive attached the file.
see the DATA sheet, we need the info in the TIME column (D) splitting into Column L and Column P, but they need to be converted to the right time format, once this is done the time sheet data sheet then needs to be populated for each employee ( Column A on Data Sheet).
47 freelancers are bidding on average $61 for this job
HI, I can do it. I'm a programmer for years and very familiar with VBA for excel automation. I can propose workflow as follow (please check PM box) Best regards, Cuong NH