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

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

Hit send by mistake...


=IF(COUNT(B3,C3)<2,"",B3+C3-TIME(0,30,0)*(((B3+C3)5/24)+((B3+C3)1/3)))


In article ,
JE McGimpsey wrote:

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)

<"Hit send by mistake..."
Did you mean that literally John?
Do you have something on your keyboard that is "hittable?", that can
initiate a "send"?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"JE McGimpsey" wrote in message
...
Hit send by mistake...


=IF(COUNT(B3,C3)<2,"",B3+C3-TIME(0,30,0)*(((B3+C3)5/24)+((B3+C3)1/3)))


In article ,
JE McGimpsey wrote:

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)

Of course.

In article ,
"RagDyer" wrote:

Do you have something on your keyboard that is "hittable?", that can
initiate a "send"?

I have one too

--
Don Guillett
SalesAid Software

"RagDyer" wrote in message
...
<"Hit send by mistake..."
Did you mean that literally John?
Do you have something on your keyboard that is "hittable?", that can
initiate a "send"?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"JE McGimpsey" wrote in message
...
Hit send by mistake...


=IF(COUNT(B3,C3)<2,"",B3+C3-TIME(0,30,0)*(((B3+C3)5/24)+((B3+C3)1/3)))


In article ,
JE McGimpsey wrote:

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 ,
"Don Guillett" wrote:

I have one too

Doesn't everyone?

I sold mine!

*JE McGimpsey* has posted this message:

In article ,
"Don Guillett" wrote:

I have one too

Doesn't everyone?

Besides taking the bait, you want me to also swallow the hook?<g
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"JE McGimpsey" wrote in message
...
In article ,
"Don Guillett" wrote:

I have one too

Doesn't everyone?

In article ,
"Ragdyer" wrote:

Besides taking the bait, you want me to also swallow the hook?<g

Well, I do live in the middle of some of the best fly-fishing area in
the country...