I'm trying to create an overtime log where text entries either add hours or charge 0 hours to a running log. I have no idea how to set it up nor write a formula that represents these values.
For exampe-fritz has 299 hours and is the lowest on the list as hours go- if he is offered a day shift and he is working, w=0 so he would not be charged the hours, or if he says yes y=10(10 = a day tour) so his 299 would now be a 309. If we were unable to contact him, u-10(he would be charged the same as a no(n=10)
I know what I want it to do just dont know how to make it happen.
Any help would be much appreciated, thanks,
Scott