Condition if Time is within a range

[Mario36]

Hi All,

I am looking to apply a condition to the attached data where

1. If the time is between 7:00AM and 4:00PM give a result as "Working Hours"

2.If the time is between 4:01PM and 11:59PM then give me "After Working Hours"

3. If the time is between 12:00AM and 6:59AM then give me "Before Working Hours"

[DataNath · Accepted solution]

Had a quick scroll through and this seems to check out for your example but please do let me know if there's issues when applying it to a larger dataset:

[binuacs]

@Mario36 One way of doing this

[dana_mcdonough]

Hi @Mario36 - take a look at this article which uses the DateTimeParse function: Multiple-IF-condition-for-Date-and-time . This combined with an IF statement should get you what you need!

[CarliE]

Hi @Mario36 

Take a look at this workbook

If this helped to solve your problem, please mark it as a solution

[Mario36]

@DataNath  Thank you. This helps.