Challenge #42: Inspire Europe '16 Grand Prix (L1)

[Supriya2203]

My solution

[fluteman]

The path i took:

Use a text input tool to create the reference table:

TimePeriod | Start | End

Early Morning | 0 | 559
Morning | 600 | 1159
Afternoon | 1200 | 1559
Evening | 1600 | 2059 
Night | 2100 | 2359

Then flag the records when they fall within a band of the reference table, as a formula:

if (([24hoursasnumber] > [Start]) or ([24hoursasnumber] = [Start])) and (([24hoursasnumber] < [End]) or ([24hoursasnumber] = [End])) then 1 else 0 endif