Login Page - Create Account

Support Board


Date/Time: Wed, 15 May 2024 21:56:57 +0000



Post From: Spreadsheet exit question

[2014-04-09 20:13:18]
User14682 - Posts: 83
I have an exit located in j29 and would like to include a code to exit at a time value / =(J41-INT(J41))>TIMEVALUE("15:05:00")

How do I incorporate time value into this code???

=IF(J8>0,OR(AND(AA4<AE4,AA5>AE5),AND(AA4<AG4,AA5>AG5)),IF(J8<0,OR(AND(AA4>AE4,AA5<AE5),AND(AA4>AG4,AA5<AG5)),FALSE))

Any help would be greatly appreciated

Thanks