Excel formula - identifying specific time within 2 time parameters

[Hakunabrotata]

Hi guys,

Apologies in advance if my question is way too simple for this forum.

I was just wondering if anyone knew the formula to identiy whether a specifc time frame falls between 2 different periods of time.

In this instance I just want to know if my time values in a column fall between 08:00:00 and 17:30:00 (Core).

If they do I want to label them as Core and If not, Non-core.

Any assistance would be greatly appreciated.

Thank you.

 

[6StringJazzer]

I answered that in your other thread.

Formula assistance

Hi everyone! Please bear with me as this is my first post so I'm not sure how best to convey a question. I'm trying to create a formula that will help me look at 2 variables in separate columns - Date/time (Column A) & Days of the week (Column B). From this data I want to identify whether this...

www.mrexcel.com

 

[Fluff]

Duplicate to: Formula assistance

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.