4 Replies Latest reply: Aug 25, 2017 11:37 AM by Sunny Talwar RSS

    Grouping time to morning, noon and evening

    Philipp Bergmann

      Dear community,


      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!