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