I done at work on a project which basis of data formatting and data analysis. The client also want their employees present in half day and full day basis. Then I clean the sheet before and by formatting or overwrite formula I done it then the client was happy and I appreciated by his