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
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
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:
=IF(MEDIAN(MOD(K2,1),"07:00","15:30")=MOD(K2,1),"Day Workers","Night Workers") copied down
Thanks... JBeaucaire and DonkeyOte the formula works just fine... It was something I was doing wrong.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks