Hi

Try entering in B3
=IF(B1TIME(9,15,0),B2,"")

If the time in B1 is greater than 9:15, then B3 will have the value that
is in B2, otherwise it will remain empty.
--
Regards

Roger Govier


"grumpy" wrote in message
...
trying to create a function that IF B1 is ( time value), then
TRANSPOSE
(number value) B2 to B3. can anyonehelp with this function