On Wed, 9 Nov 2005 12:45:23 -0800, "Peo Sjoblom"
wrote:

|=IF(Sheet1!A1="","",Sheet1!A1)
|
| you refer to another cell a (blank cell equals zero) thus the
|12:00 AM which is the same as zero time, if you format the cell as General
|you'll see 0

Ahh. I see. Thank you for that. It's a shame to have to enter an
IF statement as I have many formulas to enter-in manually. A
couple of clicks per cell would have been much easier!

However, it solves it, so thank you!

H.