Hi all,
Here is my problem: my staff has to enter over time per day.
What would be the best way to validate those entries, ie: assuming that:
A2, B2, C2 and D2 being respectively Start_am, End_am. Start_pm and End_pm?
No entry is implemented as "-" (dash symbol).
Type of validation: A2 < B2 and A2 < 9:00 and B2 < 13:00 and B2 < C2 < D2.
tia.
matfis

1. Select the cell/Range (say A2:D10). Please note that the cell reference A2
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection

2. From menu FormatConditional Formatting

3. For Condition1Select 'Formula Is' and enter the below formula

=IF(COUNT($A2:$D2)=4,OR($B2<$A2,$C2<$B2,$D2<$C2,$A 2
TIMEVALUE("9:00"),$B2TIMEVALUE("13:00")))

4. Click Format ButtonPattern and select your color (say Red)

5. Hit OK

PS: This validates only when all 4 cells are not blank

If this post helps click Yes
---------------
Jacob Skaria


"matfis" wrote:

Hi all,
Here is my problem: my staff has to enter over time per day.
What would be the best way to validate those entries, ie: assuming that:
A2, B2, C2 and D2 being respectively Start_am, End_am. Start_pm and End_pm?
No entry is implemented as "-" (dash symbol).
Type of validation: A2 < B2 and A2 < 9:00 and B2 < 13:00 and B2 < C2 < D2.
tia.
matfis

On Mon, 19 Oct 2009 06:06:01 -0700, matfis
wrote:

Hi all,
Here is my problem: my staff has to enter over time per day.
What would be the best way to validate those entries, ie: assuming that:
A2, B2, C2 and D2 being respectively Start_am, End_am. Start_pm and End_pm?
No entry is implemented as "-" (dash symbol).
Type of validation: A2 < B2 and A2 < 9:00 and B2 < 13:00 and B2 < C2 < D2.
tia.
matfis



Easy. You are only obligated to pay either

A) All hours over forty in a week as OT, OR
B) All hours over eight in a day as OT.

This task tracker does not track OT hours, but it does track all hours,
making OT validations pretty easy to add.

http://office.microsoft.com/en-us/te...CT101172771033