Ben SmithBen Smith
Ben Smith/
Location from Time
Location from Time
Location from Time

Location from Time

For
Kawalele
From
Reddit
Status
Updating
Formulas
if
if
slice
slice
test
test
Share

Location

if(test(slice(prop("Time"), 0, 2), "00|01|02|03|04|05"), "Asia", if(test(slice(prop("Time"), 0, 2), "06|07|08|09|10|11|12"), "London", if(test(slice(prop("Time"), 0, 2), "13|14|15|16|17|18|19|20"), "NY", if(test(slice(prop("Time"), 0, 2), "21|22|23"), "Spread", "Other"))))
 
Original
if(prop("Time") == "00:00", "Asia", if(prop("Time") == "01:00", "Asia", if(prop("Time") == "02:00", "Asia", if(prop("Time") == "03:00", "Asia", if(prop("Time") == "04:00", "Asia", if(prop("Time") == "05:00", "Asia", if(prop("Time") == "06:00", "London", if(prop("Time") == "07:00", "London", if(prop("Time") == "08:00", "London", if(prop("Time") == "09:00", "London", if(prop("Time") == "10:00", "London", if(prop("Time") == "11:00", "London", if(prop("Time") == "12:00", "London", if(prop("Time") == "13:00", "NY", if(prop("Time") == "14:00", "NY", if(prop("Time") == "15:00", "NY", if(prop("Time") == "16:00", "NY", if(prop("Time") == "17:00", "NY", if(prop("Time") == "18:00", "NY", if(prop("Time") == "19:00", "NY", if(prop("Time") == "20:00", "NY", if(prop("Time") == "21:00", "Spread", if(prop("Time") == "22:00", "Spread", if(prop("Time") == "23:00", "Spread", "other"))))))))))))))))))))))))
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!