Problem with IF condition to calculate overtime if falls on Sunday. Please help me.

[misterxcel]

I am having problem with constructing an IF condition for weekend overtime calculation, i have been asked to put a conditional formula for overtime if it falls on sunday of the weekdays withiin a normal overtime column so if the sunday falls anywhere in between 7 days period i have to put a condition to treat those hours worked on sunday so could you please help me if you could in this matter i would really appreciate your help as i am not really good at formulas. Please help me out. Here is the spread sheet for timesheet i am working on so you will see what i really need to accomplish.

http://www.uploadup.com/di-3QHH.jpg

in the overtime column i need to put a condition to check in date column that if date falls on sunday then the hours worked will treated as overtime straightaway and the rest of the days depends if the hours exceeds with normal working hours which is 8 hours then it will be conunted as overtime but for sunday it is different. As sunday hours will be counted as overtime. Please help. thank you.

 

[T. Valko]

I am having problem with constructing an IF condition for weekend overtime calculation, i have been asked to put a conditional formula for overtime if it falls on sunday of the weekdays withiin a normal overtime column so if the sunday falls anywhere in between 7 days period i have to put a condition to treat those hours worked on sunday so could you please help me if you could in this matter i would really appreciate your help as i am not really good at formulas. Please help me out. Here is the spread sheet for timesheet i am working on so you will see what i really need to accomplish.

http://www.uploadup.com/di-3QHH.jpg

in the overtime column i need to put a condition to check in date column that if date falls on sunday then the hours worked will treated as overtime straightaway and the rest of the days depends if the hours exceeds with normal working hours which is 8 hours then it will be conunted as overtime but for sunday it is different. As sunday hours will be counted as overtime. Please help. thank you.

If the timecard spans a 7 day work week then by default the last date entry is for Sunday.

So, all you should have to do is test the cell for actual hrs worked. Something like this entered in the Total Overtime column:

=MAX(E10,0)

Or, am I missing something?