Date validation and overtime calculations

[GordonJamieson]

I've hit a Wall

I have been trying to create a time sheet that draws table date for a
employee and then based on the hours of worked calculate the following

1) number of normal hours. Just battling with the calculation of th
time segments

2) number of overtime hours: the pay rate is x1.5
hour

3) number of hours for a public holiday:the pay rate is x 2.0 / hour

4) number of hours for a Sunday Rate: the pay rate is x 0.5 / hour

5) Is there a better way of doing the date calculation

I would greatly appreciate any help in this regard

Thank

Attachment filename: sample timebook1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=66868

 

[Biff]

Hi!

Hmmm....

When is overtime paid? Over 9 hours a day?

I can fix all your time calculations, however, this
workbook has links to another workbook and I have no idea
what info that might be so I can't do anything with the
pay rate totals!!!!!!!

Biff

 

[GordonJamieson]

This is the additional info from the linked spreadsheet that yo
enquired about

I hope this will assist

Gordo

Attachment filename: sample timebook2.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=68463

 

[Biff]

Hi Gordon!

I have many questions about your time sheet.

Can you post an email address so that I may contact you?

Biff

 

[GordonJamieson]

(e-mail address removed)