HI,

If any one could help with this i would be greatful.

I have thetime time in a1 starting at 08:00 and going down the pagein
15 mintue intervals, in the next column i have a number next to the
time.

I would like a formula to be able to read and display the second column
number depending on the time stated in cell c1 in d1.

any help would be great.

thanks
brent


--
Brento
------------------------------------------------------------------------
Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=567674