I want someone to creat a excel formula where I will punch in the clock in and clock out for my employee and on the other tabs it will cover the actual time and round it to the nearest 5 & 7 minutes interval so I can compare and monitor time clock rounding.
I have attached the sample data sheet, I would like somone to convert the formula that will populate the time in and outs based on the clock in times and also meet with legal guidleines of clock rounding.
Law Summary so it helps understand the concept
[login to view URL]
7 freelancers are bidding on average $24 for this job
i am an expert with excel formulas cause im currently handling a company database using excel . With the help of formula i did in excel and pivot table i could easily do the reporting