Date validation and overtime calculations

  • Thread starter Thread starter GordonJamieson
  • Start date Start date
G

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
 
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
 
Hi Gordon!

I have many questions about your time sheet.

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

Biff
 
Back
Top