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).
In which case I would suggest:Originally Posted by jwmjacob
![]()
=IF(MEDIAN(MOD(K2,1),"07:00","15:30")=MOD(K2,1),"Day Workers","Night Workers") copied down
Bookmarks