MonkeyNut
Member
Hi all, Could do with some help here. T&A Clock In Reports come in as csv files. Am stuck on the following:
This T&A system does not give the reports out in a very user friendly way.
Ultimately there are only 3 major things I’m looking for.
· Start time must be 6am, regardless of what time they clocked in, finish time is whenever they log out
· If the person clocks in and not out, or clocks out and not in, we must allocate them 8 working hours
· Based on the above assumptions, a sum total of all hours worked per member of staff
Column I is the one with the total time per day, however, it starts before 06h00 if they clock before then, and I cannot do any sumif formulas to get the total hours worked as the format of the data seems to be a date/time one.
Doing this manually is time consuming.
Attached is a copy of the .csv file saved as an excel file that we get from the system.
Any assistance would be greatly appreciated.
Thanks in advance
MonkeyNut
This T&A system does not give the reports out in a very user friendly way.
Ultimately there are only 3 major things I’m looking for.
· Start time must be 6am, regardless of what time they clocked in, finish time is whenever they log out
· If the person clocks in and not out, or clocks out and not in, we must allocate them 8 working hours
· Based on the above assumptions, a sum total of all hours worked per member of staff
Column I is the one with the total time per day, however, it starts before 06h00 if they clock before then, and I cannot do any sumif formulas to get the total hours worked as the format of the data seems to be a date/time one.
Doing this manually is time consuming.
Attached is a copy of the .csv file saved as an excel file that we get from the system.
Any assistance would be greatly appreciated.
Thanks in advance
MonkeyNut