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 <cubdf8$f48$1@lust.ihug.co.nz>,
"Greg Brow" <gregslaptop@ihug.com.au> 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 <jemcgimpsey-29692D.19451208022005@msnews.microsoft.com>,
JE McGimpsey <jemcgimpsey@mvps.org> 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" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-D84C78.19525608022005@msnews.microsoft.com...
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 <jemcgimpsey-29692D.19451208022005@msnews.microsoft.com>,
JE McGimpsey <jemcgimpsey@mvps.org> 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 <OwIsDklDFHA.2600@TK2MSFTNGP09.phx.gbl>,
"RagDyer" <ragdyer@cutoutmsn.com> wrote:

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

I have one too

--
Don Guillett
SalesAid Software
donaldb@281.com
"RagDyer" <ragdyer@cutoutmsn.com> wrote in message
news:OwIsDklDFHA.2600@TK2MSFTNGP09.phx.gbl...
> <"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" <jemcgimpsey@mvps.org> wrote in message
> news:jemcgimpsey-D84C78.19525608022005@msnews.microsoft.com...
> 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 <jemcgimpsey-29692D.19451208022005@msnews.microsoft.com>,
> JE McGimpsey <jemcgimpsey@mvps.org> 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 <eQ2akFuDFHA.464@TK2MSFTNGP15.phx.gbl>,
"Don Guillett" <donaldb@281.com> wrote:

> I have one too

Doesn't everyone?

I sold mine!

*JE McGimpsey* has posted this message:

> In article <eQ2akFuDFHA.464@TK2MSFTNGP15.phx.gbl>,
> "Don Guillett" <donaldb@281.com> 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" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-F9FD07.14052009022005@msnews.microsoft.com...
> In article <eQ2akFuDFHA.464@TK2MSFTNGP15.phx.gbl>,
> "Don Guillett" <donaldb@281.com> wrote:
>
> > I have one too
>
> Doesn't everyone?

In article <OoBO6eyDFHA.624@TK2MSFTNGP15.phx.gbl>,
"Ragdyer" <RagDyer@cutoutmsn.com> 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...