cdate

In a project at work I use Excel to perform analyses of some data records, which are timestamped by date and time.
I want to categorize the records by their time-of-day eg. “morning” and “afternoon”.
For this I define what is the beginning and end of each category eg. “morning”: from 07:00 to 09:00.
To find the category [...]