I have date in a cell & time in a cell .. now I need a formulae which should return if that date & time fall in business hours or not .
Assuming business hrs to be Mon - Fri - 08:00 AM to 05:00 PM
Thanks in Advance !
Last edited by vamshi57; 12-12-2009 at 07:15 PM.
Maybe =(WEEKDAY(A1, 2) < 6) * (MOD(A1, 1) >= "8:00" + 0) * (MOD(A1, 1) <= "17:00" + 0)
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
Yeah , It worked . Instead of returning "0' & "1"'s . Can that return " Prime " if time falls b/w bunisess hrs or else " NON-Prime " . Thanks much
=IF( (WEEKDAY(A1, 2) < 6) * (MOD(A1, 1) >= "8:00" + 0) * (MOD(A1, 1) <= "17:00" + 0), "something", "something else")
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks