Excel 2007 : Cell to display "Night Worker" or "Day Worker" from Date Time

I have a spreadsheet with 1,000 records of data that has 10 columns, one being (Time Started) with date and time (2/15/2010 9:34:31 AM).

I want to display in another new column (Processors) “Day workers” or “Night Workers” from the spreadsheet’s (2/15/2010 9:34:31 AM) data. I would desire 7am to 3:30pm “Day Workers” and all else “Night Workers”.

I attempted to use the formula “IF(AND(HOUR(NOW())>=7,HOUR(NOW())<=16),"Day Workers","Night Workers")” in a post recorded already, but it will only displays “Day Workers”. I am attaching my spreadsheet for clarification.

In M2:

=IF(AND(HOUR(K2)>=7,HOUR(K2)<=16),"Day Workers","Night Workers")

The formula would return different answers pending time, check you're running XL in Auto Calculation mode (ie pressing F9 does not alter the results).

Originally Posted by jwmjacob

I would desire 7am to 3:30pm “Day Workers” and all else “Night Workers”.

In which case I would suggest:

Please Login or Register  to view this content.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED .