If "day" is, say 6:00 am to 5:59 pm, One way:

=CHOOSE(2*MOD(A2+0.25,1)+1,16.5,25)




In article ,
"Brett" wrote:

How can I have a formula (if a2=day c2=$16.50 if a2=night c2=$25.00) ?