The field value settings don't make a difference, and the fields that are created new with 1.) or 2.) cannot be filtered for "1"s or 0"s, so something must be wrong with the field calculation I guess. The below formulas 1.) to 3.) work excellent for getting '1's or '0's for incidents that happened either between 8AM and 4PM, or outside of this time window,Īs long as I create a new column somewhere.ġ.) =IF(AND(A1>=8, A1=1, A1=8, B1="AM", A112), AND(OR(A1=8,'AM/PM'="AM",HOUR12), AND(OR(HOUR<=4,HOUR=12),'AM/PM'="PM")) That I am not allowed to create a new column in the source datasheet or change existing columns). Together they define the time of an incident (regarding the below problem, note Entries in the first column consist of 1,2,3,4,5,6,7,8,9,10,11, or 12, the second column consists of 'AM's or 'PM's. A database with a column (HOUR) and another column (AM/PM).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |