Time period

[Guest]

Hell
I am trying to determine if an entered time period , falls within a preset time period. For instance, Normal hours 800-1700 Mon-Sat,
A1 (Start) = Fri 04/09/04 2200
B1 (End) = Fri 04/09/04 230
C1 (Normal)= N
A2 (Start) = Fri 04/09/04 800
B2 (End) = Fri 04/09/04 50
C2 (Normal)= YE
A3 (Start) = Fri 04/09/04 2300
B3 (End) = SAT 04/10/04 030
C3 (Normal)= N
A4 (Start) = SAT 04/09/04 2300
B4 (End) = MON 04/11/04 050
C4 (Normal)= N
If any of the entered period falls within Normal hours it should be cosidered as normal

Thanks for all help
Renee

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/DateTimeWS.htm

--
Regards
Frank Kabel
Frankfurt, Germany

Hello
I am trying to determine if an entered time period , falls within a

preset time period. For instance, Normal hours 800-1700 Mon-Sat,