Thanks:  0
Likes:  0

1. I am trying to help the receptionist with the parking log and validations. 2 stamps are used. If its after 10:30 and they stay more than 2 hours then "Use a 1 day stamp". Any other time use 20 minute stamps.

This is the function
a1 10:30 time in
a2 1:30 time out
a3 2:30 elasped time

=IF(a1>0.43681&a3>0.0831,"USE ALL DAY STAMP",IF(ROUND(a3*72,0)>4,4,ROUND(a3*72,0)))

Heres the problem
IF(a1>0.43681&a3>0.0831,
If(a1>10:30am & 3 > 2:00,

How do I join these 2 conditions or does anyone have a better idea. Thanks

2. Try;
=IF(AND(A1>0.437,A3>0.10417),"USE ALL DAY STAMP","USE 20 MINUTE STAMP")

Ivan

[ This Message was edited by: Ivan F Moala on 2002-03-22 10:29 ]

3. With criteria in C1 (10:30:00 AM)
and D1 (2:00:00 )

=IF(AND(B2>\$C\$1,B2-A2>\$D\$1),"Use a 1 day Stamp","20 Minute Stamp")

4. Thanks for the help, the ladies will really appreciate this.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•