Reference time in another field

#1

I’m trying to build a formula to multiply a random number by x if the time in another field is after 12PM, and by y if the time is before 12PM. Right now here is what I have:

if field(“Start Time”) > “12:00:00 PM” THEN random(1,24) * 1.3
elseif field(“Start Time”) <= “12:00:00 PM” THEN random(1,24) * .7
end

however, I’m getting a syntax error and cannot figure it out. Help please!

#2

Try this out: https://www.mockaroo.com/53d0eac0