I'm working on a timecard project. I want to create a popup window
(userform) when the values someone inputs on the worksheet for their
regular hours + other hours does not equal the time interval they
inputed.

Example: I input that I worked from 8:00am to 4:00pm (8hr day). I can
break down my hours between regular work hours and other hours
(overtime). If the employee puts in 5 regular hours and 10 other hours
for that day, obviously that is more than the 8 hour day they claimed
they worked.


If this scenario was true, I want a window to pop up telling them that
their hours don't equal.


CAN I DO THAT?


PCStechnical

How about just letting Excel do the math from the Start and Finish times and
the user not even have to enter anything except those?

Vaya con Dios,
Chuck, CABGx3



"PCStechnical" wrote:

I'm working on a timecard project. I want to create a popup window
(userform) when the values someone inputs on the worksheet for their
regular hours + other hours does not equal the time interval they
inputed.

Example: I input that I worked from 8:00am to 4:00pm (8hr day). I can
break down my hours between regular work hours and other hours
(overtime). If the employee puts in 5 regular hours and 10 other hours
for that day, obviously that is more than the 8 hour day they claimed
they worked.


If this scenario was true, I want a window to pop up telling them that
their hours don't equal.


CAN I DO THAT?


PCStechnical

Use DataValidation and use a type of Custom and a formula

=regular_hours+overtime_hours=totals_hours

it will error if this is false.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"PCStechnical" wrote in message
ups.com...
I'm working on a timecard project. I want to create a popup window
(userform) when the values someone inputs on the worksheet for their
regular hours + other hours does not equal the time interval they
inputed.

Example: I input that I worked from 8:00am to 4:00pm (8hr day). I can
break down my hours between regular work hours and other hours
(overtime). If the employee puts in 5 regular hours and 10 other hours
for that day, obviously that is more than the 8 hour day they claimed
they worked.


If this scenario was true, I want a window to pop up telling them that
their hours don't equal.


CAN I DO THAT?


PCStechnical

connected the data validation and it doesn't seem to be working.

If I put a data validation condition in a cell that has a formula in
it, will the validation not work?


What I have: cell 1 has the formula that adds regular hours +other
hours. Cell 2 gives me the total hours worked that day (also a
formula). In cell 1, I put a data validation of these settings
Allow: custom
Formula: =n7*
*n7 is where the number of total hours is located


any sugguestions on why the warning is not popping up?


PCStech


Bob Phillips wrote:
Use DataValidation and use a type of Custom and a formula

=regular_hours+overtime_hours=totals_hours

it will error if this is false.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"PCStechnical" wrote in message
ups.com...
I'm working on a timecard project. I want to create a popup window
(userform) when the values someone inputs on the worksheet for their
regular hours + other hours does not equal the time interval they
inputed.

Example: I input that I worked from 8:00am to 4:00pm (8hr day). I can
break down my hours between regular work hours and other hours
(overtime). If the employee puts in 5 regular hours and 10 other hours
for that day, obviously that is more than the 8 hour day they claimed
they worked.


If this scenario was true, I want a window to pop up telling them that
their hours don't equal.


CAN I DO THAT?


PCStechnical

I did a test one in another worksheet that looks like this
regular hours other total
6 2 8
6 8
8 8

the demensions are columns a:c and rows 1:4

questions:
which cell do I validate?
when I tried validating in cell d3 the formula I put was (=a3+b3=c3)
and nothing popped up. Solutions?
Bob Phillips wrote:
Use DataValidation and use a type of Custom and a formula

=regular_hours+overtime_hours=totals_hours

it will error if this is false.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"PCStechnical" wrote in message
ups.com...
I'm working on a timecard project. I want to create a popup window
(userform) when the values someone inputs on the worksheet for their
regular hours + other hours does not equal the time interval they
inputed.

Example: I input that I worked from 8:00am to 4:00pm (8hr day). I can
break down my hours between regular work hours and other hours
(overtime). If the employee puts in 5 regular hours and 10 other hours
for that day, obviously that is more than the 8 hour day they claimed
they worked.


If this scenario was true, I want a window to pop up telling them that
their hours don't equal.


CAN I DO THAT?


PCStechnical

How about only posting it in 1 forum not 3.
You've got answers in all 3 now

Steve

On Wed, 04 Oct 2006 17:52:08 +0100, PCStechnical
wrote:

I'm working on a timecard project. I want to create a popup window
(userform) when the values someone inputs on the worksheet for their
regular hours + other hours does not equal the time interval they
inputed.

Example: I input that I worked from 8:00am to 4:00pm (8hr day). I can
break down my hours between regular work hours and other hours
(overtime). If the employee puts in 5 regular hours and 10 other hours
for that day, obviously that is more than the 8 hour day they claimed
they worked.


If this scenario was true, I want a window to pop up telling them that
their hours don't equal.


CAN I DO THAT?


PCStechnical

well, since this is the first time i've used this, I didn't know how
fast the responses would be. Therefore, I just tried 3 forums to
increase my chances of a quick response.

Thank you for your quick response though. I know now that this forum
works quickly.


SteveW wrote:
How about only posting it in 1 forum not 3.
You've got answers in all 3 now

Steve

On Wed, 04 Oct 2006 17:52:08 +0100, PCStechnical
wrote:

I'm working on a timecard project. I want to create a popup window
(userform) when the values someone inputs on the worksheet for their
regular hours + other hours does not equal the time interval they
inputed.

Example: I input that I worked from 8:00am to 4:00pm (8hr day). I can
break down my hours between regular work hours and other hours
(overtime). If the employee puts in 5 regular hours and 10 other hours
for that day, obviously that is more than the 8 hour day they claimed
they worked.


If this scenario was true, I want a window to pop up telling them that
their hours don't equal.


CAN I DO THAT?


PCStechnical