Ok, I have created a fairly large spreadsheet that figures all the work time for employees, including sick time, holiday, vacation, etc. My question is the way I currently have this set up, time is based on a day by day basis, i.e. Mon-Fri, and if someone were to work more than 8 hours, it would automatically give them overtime, one cell would max at 8 hours, while another would show anything over 8. I have another sheet in the workbook that sums up the entire weeks time to get a normal 40 hours, everything works great except that if someone were to get overtime, say 2 hours on a Mon-Thur, and the worker chose to take that 2 hours of that overtime time off on Fri, my weekly sheet would show 38 hours of regular time with 2 hours of overtime. How can I subtract that overtime to make my weekly hours equal 40 an zero out the 2 hours of overtime.
