More work schedule creation trouble

In my last discussion, I needed to deduct a lunch period without listing an
in and out time. That problem was rectified. Thank you Gord Dibben!!! Now I
want to total the number of scheduled hours for the week. If I have an
associate scheduled off for a day, the daily hours worked calculation is
blown, thus no week total is available. Here's an example of the daily hours
worked formula - =TEXT((O3-N3)-TIME(0,30,0),"h:mm"). I have created dropdowns
for the in and out cells that contain times (ie 7:00 AM, 6:00 PM). I would
like to be able to have a zero time worked value in the daily hours worked
cell, which I believe should take care of my weekly total hours worked
formula.

Thank you in advance!!!

Paul

Hi!

If someone is off on a day then there will not be an "In" or "Out" time. So,
maybe something like this:

=IF(COUNT(N3:O3)<>2,0,TEXT((O3-N3)-TIME(0,30,0),"h:mm"))

Biff

"Paul" <[email protected]> wrote in message
news:[email protected]...
> In my last discussion, I needed to deduct a lunch period without listing
> an
> in and out time. That problem was rectified. Thank you Gord Dibben!!! Now
> I
> want to total the number of scheduled hours for the week. If I have an
> associate scheduled off for a day, the daily hours worked calculation is
> blown, thus no week total is available. Here's an example of the daily
> hours
> worked formula - =TEXT((O3-N3)-TIME(0,30,0),"h:mm"). I have created
> dropdowns
> for the in and out cells that contain times (ie 7:00 AM, 6:00 PM). I would
> like to be able to have a zero time worked value in the daily hours worked
> cell, which I believe should take care of my weekly total hours worked
> formula.
>
> Thank you in advance!!!
>
> Paul

Biff,

Thank you very much for the help. Now I've encountered another problem. If a
part timer works less than 6 hours, they do not get a lunch break (they get a
15 minute break that is not deducted from their time. Is this another 'IF'
command? I'm being a little lazy here, only because of the hour. I'll attempt
this again tomorrow.

Thanks again!!!

"Biff" wrote:

> Hi!
>
> If someone is off on a day then there will not be an "In" or "Out" time. So,
> maybe something like this:
>
> =IF(COUNT(N3:O3)<>2,0,TEXT((O3-N3)-TIME(0,30,0),"h:mm"))
>
> Biff
>
> "Paul" <[email protected]> wrote in message
> news:[email protected]...
> > In my last discussion, I needed to deduct a lunch period without listing
> > an
> > in and out time. That problem was rectified. Thank you Gord Dibben!!! Now
> > I
> > want to total the number of scheduled hours for the week. If I have an
> > associate scheduled off for a day, the daily hours worked calculation is
> > blown, thus no week total is available. Here's an example of the daily
> > hours
> > worked formula - =TEXT((O3-N3)-TIME(0,30,0),"h:mm"). I have created
> > dropdowns
> > for the in and out cells that contain times (ie 7:00 AM, 6:00 PM). I would
> > like to be able to have a zero time worked value in the daily hours worked
> > cell, which I believe should take care of my weekly total hours worked
> > formula.
> >
> > Thank you in advance!!!
> >
> > Paul
>
>
>

Hi!

You'd have to have some means of identifying the employee as a PT'er. Also,
what happens if a PT'er works 6 or more hrs? Do they then get the normal 30m
break?

Something like this:

=IF(AND(some_cell="PT",O3-N3<6),TEXT(O3-N3,"h:mm"),not_known_to_me)

Biff

"Paul" <[email protected]> wrote in message
news:[email protected]...
> Biff,
>
> Thank you very much for the help. Now I've encountered another problem. If
> a
> part timer works less than 6 hours, they do not get a lunch break (they
> get a
> 15 minute break that is not deducted from their time. Is this another 'IF'
> command? I'm being a little lazy here, only because of the hour. I'll
> attempt
> this again tomorrow.
>
> Thanks again!!!
>
> "Biff" wrote:
>
>> Hi!
>>
>> If someone is off on a day then there will not be an "In" or "Out" time.
>> So,
>> maybe something like this:
>>
>> =IF(COUNT(N3:O3)<>2,0,TEXT((O3-N3)-TIME(0,30,0),"h:mm"))
>>
>> Biff
>>
>> "Paul" <[email protected]> wrote in message
>> news:[email protected]...
>> > In my last discussion, I needed to deduct a lunch period without
>> > listing
>> > an
>> > in and out time. That problem was rectified. Thank you Gord Dibben!!!
>> > Now
>> > I
>> > want to total the number of scheduled hours for the week. If I have an
>> > associate scheduled off for a day, the daily hours worked calculation
>> > is
>> > blown, thus no week total is available. Here's an example of the daily
>> > hours
>> > worked formula - =TEXT((O3-N3)-TIME(0,30,0),"h:mm"). I have created
>> > dropdowns
>> > for the in and out cells that contain times (ie 7:00 AM, 6:00 PM). I
>> > would
>> > like to be able to have a zero time worked value in the daily hours
>> > worked
>> > cell, which I believe should take care of my weekly total hours worked
>> > formula.
>> >
>> > Thank you in advance!!!
>> >
>> > Paul
>>
>>
>>

I should not have specified 'part timer'. Actually, a full timer can have
less than 6 hours on a given day (full time hours being met on other days). I
think all I need is something that recognizes whether the associate works
less than 6 hours and does not get a 30 minute lunch. By the way, your
formula off my first post worked fine.

Thanks again for all your help!!!

"Biff" wrote:

> Hi!
>
> You'd have to have some means of identifying the employee as a PT'er. Also,
> what happens if a PT'er works 6 or more hrs? Do they then get the normal 30m
> break?
>
> Something like this:
>
> =IF(AND(some_cell="PT",O3-N3<6),TEXT(O3-N3,"h:mm"),not_known_to_me)
>
> Biff
>
> "Paul" <[email protected]> wrote in message
> news:[email protected]...
> > Biff,
> >
> > Thank you very much for the help. Now I've encountered another problem. If
> > a
> > part timer works less than 6 hours, they do not get a lunch break (they
> > get a
> > 15 minute break that is not deducted from their time. Is this another 'IF'
> > command? I'm being a little lazy here, only because of the hour. I'll
> > attempt
> > this again tomorrow.
> >
> > Thanks again!!!
> >
> > "Biff" wrote:
> >
> >> Hi!
> >>
> >> If someone is off on a day then there will not be an "In" or "Out" time.
> >> So,
> >> maybe something like this:
> >>
> >> =IF(COUNT(N3:O3)<>2,0,TEXT((O3-N3)-TIME(0,30,0),"h:mm"))
> >>
> >> Biff
> >>
> >> "Paul" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > In my last discussion, I needed to deduct a lunch period without
> >> > listing
> >> > an
> >> > in and out time. That problem was rectified. Thank you Gord Dibben!!!
> >> > Now
> >> > I
> >> > want to total the number of scheduled hours for the week. If I have an
> >> > associate scheduled off for a day, the daily hours worked calculation
> >> > is
> >> > blown, thus no week total is available. Here's an example of the daily
> >> > hours
> >> > worked formula - =TEXT((O3-N3)-TIME(0,30,0),"h:mm"). I have created
> >> > dropdowns
> >> > for the in and out cells that contain times (ie 7:00 AM, 6:00 PM). I
> >> > would
> >> > like to be able to have a zero time worked value in the daily hours
> >> > worked
> >> > cell, which I believe should take care of my weekly total hours worked
> >> > formula.
> >> >
> >> > Thank you in advance!!!
> >> >
> >> > Paul
> >>
> >>
> >>
>
>
>