This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Since you mentioned the numeric conversion process, I'll go ahead and how how that could be done so you have an alternative solution available. Field types and formatting are probably the most tricky thing to get sorted in these cases. If the ideas presented don't work in your application, share an example of the input date/time format and we can help get you on the right track.
I use two formula field to convert the date time value into an numeric hour value, then a second to classify. This could be combined into a single formula if you so desire.
Thank you Esther, I'll try it out and see if it would work!
This email and any attachments are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system immediately. If you are not the intended recipient you must not copy this message or attachment or disclose the contents to any other person.
So when I use your method to fill in all times of the day with the specific time period, I have one issue. When working at 20:00 (8PM) to Midnight (11:59:59). I run into an issue with it loop continuously.