Not sure why you need a macro. A worksheet function works fine:
=IF(COUNT(B3,C3)<2,"",B3+C3-TIME(0,30,0)*((B3+C3)5/24)
In article ,
"Greg Brow" wrote:
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
|