Group by Time

[Former Member]

I am trying to group all the calls we had. I want all the day time calls from 7am to 9pm in one group and the rest in another. The field is formatted: 1/1/2008 7:26:14PM.

[Former Member · Accepted solution]

create a formula with:

if time({datetime.field}) in time(7,0,0) to time(20,59,59) then "Daytime Calls"
else "Nighttime Calls";

Group on this formula.

[Former Member · Accepted solution]

Worked perfect! Thank you.