validate time entries linked to each other

M

matfis

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
 
J

Jacob Skaria

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 Format>Conditional Formatting>

3. For Condition1>Select 'Formula Is' and enter the below formula

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

4. Click Format Button>Pattern 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
 
W

WallyWallWhackr

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/templates/TC300053871033.aspx?CategoryID=CT101172771033
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top