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

[cmoussa]

[robert-headington]

#42

[Bennu]

Spoiler

[martinson]

6:40

[nSpire]

Spoiler

 

[Dominic_Brady]

My solution :)

[JBevan89]

My Solution attached.