Roster
I have asked this before but I am looking to have a spreadsheet that will
calculate the hours worked minus their meal breaks. I would like to do 2
things:
1st one is :
We work more than 5 hours we need to have a 30 minute meal break, If we
work more than 8 hours we have to have an hour.
Can i make a macro that will calculate this automatically.
part 2:
Is it possible to make excel not show the results unless the work times have
been inserted into cells b3 and c3.
Thanks in advance
Greg
|