Problem:

I have 4 worksheets in the same workbook: sheet1 sheet2 sheet3 sheet4
I want to get cell B10 of sheet4 to get info from cells B5 of sheets
1,2, & 3
BUT: Only one of those 3 cells will have something in it to print to
B10,
Else if none of those cells has anything then leave it blank in B10
The cells are formatted in Time: 5:00 pm and such

I've been trying to get a formula to work trying different methods and
I get these results: #value, 12:00 am, etc
I can get it to print any cell that has something but if none of those
cells has anything it prints #value, 12:00 am

Thanks in advance,
monkeyhop


--
monkeyhop
------------------------------------------------------------------------
monkeyhop's Profile: http://www.excelforum.com/member.php...o&userid=34012
View this thread: http://www.excelforum.com/showthread...hreadid=537772