Hi I have a worksheet. It has got in time and out time. I want to how much an employee before 03:30pm and after 03:30pm. e.g. Clock In - A1-12:30 pm and Clock Out A2-06:20 pm. The result should be AM Hours = 3.0 and PM Hours = 2.50. Would appreciate if someone helps me out with the formula.