Hi,
I'm trying to create a timekeeping spread sheet for staff. I have a start time column, and a finish time column, both formatted as hh:mm and have entered the time using 24 hr time.
I've used the third column to calculate the hours worked using the B2-A2 (Finish time - start time). All of this works fine, the problem is that we only pay their time less breaks, so I have created a table array showing the actual time worked, and then in the second column, the corresponding time we will pay. I am trying to create a VLOOKP column next to the total hours column, which will return the time that we need to pay, less breaks.
I'm getting an intermittent #NA error, supposedly caused by the cell returning the B2-A2 result. The strange thing is that if I delete the formula, and manually enter the hours worked, then the VLOOKUP works perfectly, and I don't get NA errors. I think that it's a format or value problem, but I can't seem to figure out why, or how to fix it. Any ideas????
I'm trying to create a timekeeping spread sheet for staff. I have a start time column, and a finish time column, both formatted as hh:mm and have entered the time using 24 hr time.
I've used the third column to calculate the hours worked using the B2-A2 (Finish time - start time). All of this works fine, the problem is that we only pay their time less breaks, so I have created a table array showing the actual time worked, and then in the second column, the corresponding time we will pay. I am trying to create a VLOOKP column next to the total hours column, which will return the time that we need to pay, less breaks.
I'm getting an intermittent #NA error, supposedly caused by the cell returning the B2-A2 result. The strange thing is that if I delete the formula, and manually enter the hours worked, then the VLOOKUP works perfectly, and I don't get NA errors. I think that it's a format or value problem, but I can't seem to figure out why, or how to fix it. Any ideas????
