This content has been marked as final. Show 4 replies
I have a field called 'visit_last_action_time' which delivers me the exact user's time of last action, formatted as "hh:mm:ss" (e.g. "10:03:03")
Now I want to group these time stamps into Morning, Noon and Evening.
I tried the if function:
=if (visit_last_action_time > '12:00:00', 'Morning')
but it does not work properly, since the time stamps of different dates are not clustered together.
Can anyone help me?
Thank you so much in advance!