Hey there Just one more question with formulaes.......
I'm not very good with words so I'm going to state what I'm trying to do. I'm trying to calulate employee's hours which with help from earlier have solved the problem. The thing is.... I need to deduct their breaks from the hours worked. I have tried using an IF funcation but to no avial. Could you tell me which function to use for this following example and if possible could you fully type out the equation? Any shifts that IS UNDER 6 hours will remain the same. Any shifts that IS OVER 6 hours and ABOVE will need to be deducted 30mins from their total hours. so Jenny who worked for 6 hours will have her break deducted hence her actual working hours was 5:30 hours Kind regards Johans _________________________________________________________________ Try Live.com - your fast, personalized homepage with all the things you care about in one place. http://www.live.com/getstarted --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
