excel 2003 formula
 

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.
--
craig phila

excel 2003 formula
 

=IF(AND(A1<0.5,B10.5416666666666),0.5,0)

--
Gary''s Student - gsnu200779

excel 2003 formula
 

Here's another way......

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

"Gary''s Student" wrote:

=IF(AND(A1<0.5,B10.5416666666666),0.5,0)

--
Gary''s Student - gsnu200779

excel 2003 formula
 

Or let Excel do some of the arithmetic and use
=IF(AND(A1<0.5,B113/24),0.5,0)
--
David Biddulph

"Gary''s Student" wrote in message
...
=IF(AND(A1<0.5,B10.5416666666666),0.5,0)

--
Gary''s Student - gsnu200779