1. ## Calculating Overtime (2007)

I have a Spreadsheet where i need to calculate Normal time & overtime

1) The normal hours is Monday to Thursday is 07:30 to 16:30-all hours worked before 07:30 and after 16:30 is overtime and must be calculated automatically. 0.50 must be deducted from Normal time to cater for Lunchtimes
2) All time worked on a Saturday & Sunday must be calculated as overtime

I would like a formula to do this for me.

Your assistance will be most appreciated

Regards

Howard

2. ## Re: Calculating Overtime (2007)

In G8: =IF(OR(ISBLANK(E8),ISBLANK(F8)),"",IF(WEEKDAY(C8,2 )>5,0,24*(MIN(TIME(16,30,0),F8)-MAX(TIME(7,30,0),E8))-0.5))
In H8: =IF(OR(ISBLANK(E8),ISBLANK(F8)),"",IF(WEEKDAY(C8,2 )>5,24*(MIN(TIME(16,30,0),F8)-MAX(TIME(7,30,0),E8)),24*(MAX(TIME(7,30,0)-E8,0)+MAX(F8-TIME(16,30,0),0))))

and fill down as far as needed.

3. ## Re: Calculating Overtime (2007)

Hi Hans

Thanks for the help

Much appreciated

Regards

Howard

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•