Sheet.jpg
I have attached a picture for you guys.
I am accountant in a small business.
As you can see in the image I have double Arrival & Exit timing.
I have double it because if an employee goes out for any kind of personal work he will write exit time on his sheet if he returns on the same day he will write arrival timing and when his duty duration is finished he will write exit.
Now let's get on point I wanted to use such kind of formula that I would be able to just write timings, and the late minutes column & overtime column will show the late minutes and over time minutes by formula.
If any employee is late more than 15 minutes his timing will be written in late minutes column.
Usually total employee working minutes in my company is 540 min per day if he gives more than 540 minuter in my company it will be considered overtime.
Kindly help me if you can.
I am little weak in VBA but if you would help me I would be able do something or it could be done without vba.
Tell me about the format if you understand it or not.
Bookmarks