You need to refine your time boundaries:

DAY SHIFT = 700 hrs to 1900 hrs
NIGHT SHIFT 1900 hrs to 700 hrs
27/06/2009 7:00:00 PM

Based on your shift times, 27/06/2009 7:00:00 PM could be both shifts. It
could be either the end of day shift or the beginning of night shift.


--
Biff
Microsoft Excel MVP


"John Calder" wrote in message
...
Hi

I use Excel 2K

In cell F13 i have:-

27/06/2009 7:00:00 PM

In cell G13 I would like a formula that says that if G13 is greater than
or
eqaul to 27/06/2009 7:00:00 PM and less than 27/06/2009 7:00:00 AM then
"NIGHT"

or

If G13 is greater than or equal to 27/06/2009 7:00:00 AM and greater than
less than 27/06/2009 7:00:00 PM then "DAY"


We run the business on a 24 hour clock

Example

DAY SHIFT = 700 hrs to 1900 hrs
NIGHT SHIFT 1900 hrs to 700 hrs

I need a cell that displays if it is NIGHT or DAY

Hope I have explained myself

Thanks

John