thank you vletm. You are great. One more thing. If i need to minus some hours in the sheet, how can do that? For example instead of adding one hours in the Overtime, i need to minus 2 hours.
Hi Vletm,
This is what i expected. thank you so much. I did not see any formulas or VBA codes in the excel sheet. Could you please explain where it is hidden? I want to replicate the same in other excel sheets too.
This is little complicated and i need desperate help from someone..
In the schedule sheet i have schedule date and Overtime hours. Wherever the hours are updated (hh:mm:ss) it means associates worked for 9 hours.
In the Overtime columns those are actual over time worked by the associate...