Hi, new on here but what I need for work is option buttons to be used with a formula. here is a quick example of what I have at the moment.
Shift start 06:30 Break 1 Break 2 Break 3 All 3 Breaks
Shift Finish 14:45 (=formula for total shift times minus break shown so break one is 20 minutes total shift time is 8 hrs 15 Mins) I have the formulas in to take away the breaks from the total shift to which I have further figures of the amount produced per hour and this becomes an average per day for the shift 1 & 2. What I want is instead of having break 1 (20 Mins) Break 2 exc. having the formulas underneath for me to copy that time to the third box lower down to complete the rest of the calculation.
What I would love is if someone could tell me how I can put in buttons and attach the formula to them to take away the break time from these shift start/finish but so that they will all add up if i select down for break one and two but worked through break 3. Is there a way to do this cause i would prefare to do it rather quickly and the others in the office wont know the calculations so if i could put in a few (around 9 - 12) option buttons it ould be a lot off my mind.
Thanks in advance for the help
floyd
Shift start 06:30 Break 1 Break 2 Break 3 All 3 Breaks
Shift Finish 14:45 (=formula for total shift times minus break shown so break one is 20 minutes total shift time is 8 hrs 15 Mins) I have the formulas in to take away the breaks from the total shift to which I have further figures of the amount produced per hour and this becomes an average per day for the shift 1 & 2. What I want is instead of having break 1 (20 Mins) Break 2 exc. having the formulas underneath for me to copy that time to the third box lower down to complete the rest of the calculation.
What I would love is if someone could tell me how I can put in buttons and attach the formula to them to take away the break time from these shift start/finish but so that they will all add up if i select down for break one and two but worked through break 3. Is there a way to do this cause i would prefare to do it rather quickly and the others in the office wont know the calculations so if i could put in a few (around 9 - 12) option buttons it ould be a lot off my mind.
Thanks in advance for the help
floyd
