Help Needed - Column Formula - Time of Day (Summarize by Before 5pm and After 5pm)
Dear Community,
At a high-level I'm trying to categorize completed-activities by the time of day they were completed.
More specifically, I'm trying to summarize the # of completed activities, that meet a certain criteria, by "Before 5pm" and "After 5pm".
I've tried a variety of ways (e.g., Casting the Completed Date to a Time, Substringing just the hour, etc.). I haven't had much luck so far.
Any help from someone who has done this before is greatly appreciated.
Regards,
Matt
At a high-level I'm trying to categorize completed-activities by the time of day they were completed.
More specifically, I'm trying to summarize the # of completed activities, that meet a certain criteria, by "Before 5pm" and "After 5pm".
I've tried a variety of ways (e.g., Casting the Completed Date to a Time, Substringing just the hour, etc.). I haven't had much luck so far.
Any help from someone who has done this before is greatly appreciated.
Regards,
Matt
0