Hi,
In the enclosed file,
1. Column B and C are entered time in 24 hours format which is basically IN and OUT time of employees
2. Column D is entered number of hours an employee is expected to work
Help Needed on Below
3. In Column C, I am doing C-B to get the hours and minutes an employee is worked but if out time is 1:00 a.m. it does not work (Refer E6)
4. In Column F, I need to calculate the number of hours and minutes an employee has worked if Hours present > working hours
Request help please
Bookmarks