trying to write a formula ivolving data validation

[melben]

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 ??

 

[mangesh_yadav]

Hi Melben,

no problem.

Firstly I'm using a simple formula to copy the contents of 1 cell int
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 th
contents if there is an actual time written into the cell ?

I don't think there is, because time is basically a number and exce
cannot differentiate between two numbers whether it is a time or
simple number.

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

Can you give your sample data with expected answer and cases.

Manges