Hi
Im struggling with a particular formula issue, and not sure whether this can be done or whether it will need to be done with VBA.
The page attached contains a table of rates, and a timesheet. the time sheet contains only hours, and teh table contains the rates.
What I would like to have as a total, is the correct end value i.e hours multiplied by correct rate for the date in the top of the column where the time is kept.
I've managed to work out how to select the rate using match and index, but I'm struggling to get the rate to multiple the hours and then display the correct total. my work in progress is attached.
I had considered just having both the rate and the hours on the same sheet but everyone has access to imput their times, and the rates ... well get in teh way and cause more hassle than they are worth, if people get to see what others are charged out at.
as the time sheet expands and the rates are increased from time to time, I need alway to retain the old rate that was applicable at the time the work was carried out, not just the newest rate.
any help would be greatly appreciated.
Bookmarks