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

[JeremyGonzva]

.

[AMansour]

Here's my solution

Spoiler

[AngelosPachis]

My solution for challenge #44 - failed to do it in under 10 mins however. needed about 12

Spoiler

[Sylvana]

My solution.

I take the time ranges as text input and appended it:

Spoiler

[Jean-Balteryx]

Here is my solution !

[joshuaburkhow]

Went with the IF statement but many ways to get that Time allotment

[deviseetharaman]

Spoiler

[maazinh]

Within 10 but seems some questions were taken out?

[MikeMcFadden]

Here's my solution

Spoiler

1) Input tool (sheet names) -> dynamic input tool => full data set
2) Find/replace tool =>  reclassified lighting conditions
3) DateTime tool => date format
4) Select (change from vstring to int) -> formula (nested if statements) => time buckets

[jarrod]

nice. 4:20 minutes. on to lap 2

Spoiler