looking to construct a working spreadsheet to calculate the payable working hours based on day and time.
i have the necessary values for it, but i need to translate it into reference tables for the excel to work on
the excel will need to refer to tables based on weekdays,sat, sun/ph depending on the working date being keyed in or selected
my idea is to create dropdown rows to select the date/time and the excel will refer to the reference to display the correct payable manhours
have attached a sample of the values needed to be translated...
http://imageshack.us/photo/my-images...nhrsample.jpg/
Bookmarks