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"

Time Entry.csv

Expression

Accepted answers

DataNath

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:

Working hours flags.yxmd

All comments

DataNath

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:

Working hours flags.yxmd

binu_acs

@Mario36 One way of doing this

Hours_0926.yxmd

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

Time Range.yxzp

Mario36

@DataNath Thank you. This helps.

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235