Calculate hours from table (1 Viewer)

[y2k]

Is it possible to do the following? I want to create a table which would list every date of the year 2002 and a corresponding number of hours, eg for Monday the hours would be 8 but for Saturday the hours would be 0. Then I want users to be able to enter a "from date" and a "to date" in another table that would look-up the table with the "number of hours" and calculate how many hours occured during the two dates. Am I making any sense at all here?!!?!

Can anybody help?

 

[Alexandre]

You are making it too complicated. You would let the users enter 2 dates, and write a function that would use theses dates, take out the week ends and multiplicate per 8 the remaining number of days.
Functions calculating the number of working days were already posted a few times on this forum, so you should try a search on these key words.