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 <[email protected]>,
"Greg Brow" <[email protected]> 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 <[email protected]>,
JE McGimpsey <[email protected]> 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" <[email protected]> wrote in message
news:[email protected]...
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 <[email protected]>,
JE McGimpsey <[email protected]> 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 <[email protected]>,
"RagDyer" <[email protected]> wrote:

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

I have one too

--
Don Guillett
SalesAid Software
[email protected]
"RagDyer" <[email protected]> wrote in message
news:[email protected]...
> <"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" <[email protected]> wrote in message
> news:[email protected]...
> 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 <[email protected]>,
> JE McGimpsey <[email protected]> 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 <[email protected]>,
"Don Guillett" <[email protected]> wrote:

> I have one too

Doesn't everyone?

I sold mine!

*JE McGimpsey* has posted this message:

> In article <[email protected]>,
> "Don Guillett" <[email protected]> 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" <[email protected]> wrote in message
news:[email protected]...
> In article <[email protected]>,
> "Don Guillett" <[email protected]> wrote:
>
> > I have one too
>
> Doesn't everyone?

In article <[email protected]>,
"Ragdyer" <[email protected]> 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...