If Function

[Parra]

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

 

[Ivan F Moala]

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

 

[Dave Patton]

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")

 

[Parra]

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