Formula to identify time trigger

[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.

Quote Reply

 

[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.