I have a Creation Time and Creation Date field for each record and want to determine a Session Number for a conference for each record based on those times and dates.
I started to put together an IF statement but wasn't sure how to represent the time. For example if the time for Session 1 is 28/09/17 and between 9AM and 12Noon, Session 2 is 28/9/17 between 1PM and 4PM, Session 3 is 29/9/17 between 9.30AM and 12:30PM etc.
Any help in how to write the IF calculation? or is there a better way?