Sorry mangesh, I still have a couple of questions if thats o.k

Firstly I'm using a simple formula to copy the contents of 1 cell into
another cell on a different worksheet, this is in regards to the time.
Is there anyway that I can write that ormula so that it only shows the
contents if there is an actual time written into the cell ?

Also, with the last formula that you gave me in regards to the food and
beverage, I'm using that over 3 cells now but when i select something
from my lists in 2 cells the 3rd cell which has nothing selected is
showing a value of $0.00, is there any other way around this ??


--
melben
------------------------------------------------------------------------
melben's Profile: http://www.excelforum.com/member.php...o&userid=23619
View this thread: http://www.excelforum.com/showthread...hreadid=373824