- Mar 13, 2015
Hi All - I need your help to find out a way to calculate the end time based on Start Time and hours. For instance, I have 9 AM in COL A and 32 hours in Col B, Col C should reflect 6.00 PM irrespective of the date. The reason is every day i am working 8 hours per day and my timing starts at 9.00 AM and ends at 6.00 PM, considering the 1 hour lunch, 32 hours will be in between 9.00 AM (Monday) to 6.00 PM (Thursday). It needs to be reset the end time if it exceeds more than 8 hours. Please note i dont need which day at all only timing is fine for me. your help greatly appreciated.