Hi,
I need to create a formula that categorizes period of the day the Day - from 07am to 06:59pm would be day shift and night shift from 19pm to 06:59am. However the table where the data came from have date and time format and I wish to ignore date. Any suggestion. I use crystal XI.