i need a formula that I can use to calculate hours for time in lieu, an example would be if I worked on extra on a certain day , I want to take those hours worked and add 4 hours to it, then at the end of the week, I want to be able to add all those hours up in total.
so an example would be worked 3 hours extra when I am on call, I am paid the 3 hours plus an additional 4 hours for being called in.
Solved by M. C. in 15 mins