I am charting when events happen. The time they happen is recorded by the hour it occurred in. For example, if the event happened at 12:30am than the time reference is 0, if it happens at 1:30am the time reference is 1, finishing with a 11:30pm event would get a 23 reference. I want to record the event times in four time periods (AM1 = 0 TO 5, AM2 = 6 TO 11, PM1 = 12 TO 17, AND PM2 = 18 TO 23). Here is the statement I want to make in words:
If cell A1 is greater than or equal to zero and less than or equal to five, then enter AM1 in cell B2, or if A1 is greater than or equal to 6 and less than or equal to 11, then enter AM2 in cell B2, A1 is greater than or equal to 12 and less than or equal to 17, then enter PM1 in cell B2, otherwise enter PM2 in B2.
A1 B2 2 AM1 7 AM2 15 PM1 20 PM2
Bookmarks