Hakunabrotata
New Member
- Joined
- Jul 6, 2022
- Messages
- 11
- Office Version
- 365
- 2021
- Platform
- Windows
Hi guys (@Fluff/@6StringJazzer) Apologies for the duplication of the post today - I couldn't find my previous one and thought it had accidentally been deleted (it didn't show up on my profile or number of asked questions). Unfortunately both newer posts were closed off and my query hadn't been answered. It was similar to a query I asked yesterday but that post involved looking at a cell with dates, whereas this is simply just looking at a time format of HH:MM:SS (I tried using the same formula suggested yesterday but it didn't work).
I've just re-attached the query which I'm still needing assistance with if that's okay?
-----------------------------
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 in advance.
I've just re-attached the query which I'm still needing assistance with if that's okay?
-----------------------------
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 in advance.