excel 2003 formula

[lotus lover]

howdy. i hope you can help me with this simple formula.

cells A1 and B1 are time formatted. cell C1 is number formatted.

if cell A1 shows a time before noon and cell B1 shows a time after 1:00pm, i
want cell C1 to post .50. if either of these conditions is not met, i want
cell C1 to post 0.00.

how do i write the formula in cell C1?

thank for the assist.

 

[Gary''s Student]

=IF(AND(A1<0.5,B1>0.5416666666666),0.5,0)

 

[daddylonglegs]

Here's another way......

=(A1<"12:00"+0)*(B1>"13:00"+0)/2

 

[David Biddulph]

Or let Excel do some of the arithmetic and use
=IF(AND(A1<0.5,B1>13/24),0.5,0)