Automated Manhours Calculation Worksheet

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/

Hi DarthGW

unfortunately the link to your jpg is not showing anything. Why not put it on an Excel sheet and upload it?

Regards
Alastair

this is the excel file i am currently using.
some of the timings i still have to manually calculate
i have attached the jpeg again which is the base i am constructing a new calculator on and meant to be highly automated.

Hi DarthGW

What is the rate for:

Sunday Normal
Sunday Overtime
Public Normal
Public Overtime

If any of these are the same, do you want to always have them teh same, or do you need the option to have them different in the future?

Regards
Alastair

Hi DarthGW

I note that although you refer to Sunday, making no mention of Saturday, your formula refers to Saturday.

Although the spreadsheet is somewhat spread out, it should be easy for anyone to understand how the figures are calculated.

I have guessed at some rates for Saturday, Sunday and public holidays. Let me know if they need amending.

Regards
Alastair

hello alastair
i am really thankful for the effort u have put in for the worksheet. i am getting some of my colleagues to test out the worksheet and feedback to me.
just to check, i understand that you are using the native excel formulas to churn out the manhours instead of cross-refer to the data that i have provided?