help creating a formula (maybe a mocros) in excel to calculate break entitlement

[smoozey]

Hi there, i am trying to create a new break plan at my work and I need a calculation to tell us what breaks the employee is entitled to during their shift, I currently have a column for their start time, a column for their end time and then 4 columns each representing a different break ( 15 min, 15 min, 30 min and 60 min) and then a total hours column. I basically want a tick or similar to appear in the break columns when the employee is entitled to the break, so if the employee is on a 8 hour shift, they are entitled to 2 15 minute breaks and one 60 minute break, so I want a macro that will result in a tick in both 15 boxes and the 60 box when the start and end times are entered (I have already done the formula to calculate the total hours worked) Can anyone tell me what formula I need to do this?

[JeteMc]

This thread has been posted multiple times. There are replies to this question in the thread http://www.excelforum.com/showthread...97#post4553497

[FDibbins]

Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

Thread Closed.

http://www.excelforum.com/showthread.php?t=1168360