Hi Alanna,
Have you had a chance to look at the db I posted? What is the issue with those calculations? If you could explain it I could try to help some more. I see the link you posted in your last post has a sample form to calculate the overtime, have you tried to input the data for 1355 and see what you get?
Here is what mine shows for the details:
DEPT USR_NAM EMP_NO User WEEK_NUM TIMDATE WEEK_TO_DATE WEEK_TO_PREV DATE_TOT_HRS REG OT 028 FELDMAN, DEBBIE Debbie F 1355 1 2/25/2018 0:00 8.75 0 8.75 8 0.75 028 FELDMAN, DEBBIE Debbie F 1355 1 2/26/2018 0:00 17.983 8.75 9.233 8 1.23 028 FELDMAN, DEBBIE Debbie F 1355 1 2/28/2018 0:00 27.616 17.983 9.633 8 1.63 028 FELDMAN, DEBBIE Debbie F 1355 1 3/2/2018 0:00 38.283 27.616 10.667 8 2.67 028 FELDMAN, DEBBIE Debbie F 1355 1 3/3/2018 0:00 48.25 38.283 9.967 1.717 8.25 028 FELDMAN, DEBBIE Debbie F 1355 2 3/4/2018 0:00 9.05 0 9.05 8 1.05 028 FELDMAN, DEBBIE Debbie F 1355 2 3/5/2018 0:00 18.183 9.05 9.133 8 1.13 028 FELDMAN, DEBBIE Debbie F 1355 2 3/6/2018 0:00 27.583 18.183 9.4 8 1.40 028 FELDMAN, DEBBIE Debbie F 1355 2 3/7/2018 0:00 32 27.583 4.417 4.417 0.00 028 FELDMAN, DEBBIE Debbie F 1355 2 3/9/2018 0:00 42.867 32 10.867 8 2.87 028 FELDMAN, DEBBIE Debbie F 1355 2 3/10/2018 0:00 52.684 42.867 9.817 0 9.82
Cheers,
Vlad