What is the definition of day and night. Let's says day is 06:00 to 18:00,
then assuming A2 is just time

=IF(OR(A2<--"06:00:00",A2=--"18:00:00"),25,16.5)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brett" wrote in message
...
How can I have a formula (if a2=day c2=$16.50 if a2=night c2=$25.00) ?