Skip to Content
0
Former Member
Jun 11, 2009 at 04:30 PM

Formula to categorize period of the day

103 Views

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.