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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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