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!

       

      Best


      Philipp