total in column Q is supposed to charge any time over 2.5 hrs from column U at a rate of $43/hr during weekdays.. After 1800 on weekends and holiday hourly rate is $64
I had someone create these formulas for me over the weekend but it doesn't calculate correctly
example, row 42 has 5.25 hours in column U. time over 2.5 hrs is = 1.75. should calculate 1.75*43=75.25. this should be added to the total in column Q. column Q should be 194.25 not 119
Also row 46 column U is less than 2.5 but something is added to column Q. Since column U is less than 2.5 Column Q should be 275
Solved by X. J. in 17 mins