=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


--

Regards,

Peo Sjoblom

"Howie" wrote in message
...
I'm using a formula to copy a time from one cell to another
across sheets. The format of the time is h:mm AM/PM.

However, when the formula references an empty cell, it puts in a
default value of 12:00 AM and I need it to remain blank, (just as
the referenced cell)
It's such a simple copy formula. ie:

=sheet1!A1

I can't see anything causing this.
Has anyone any ideas?

thanks in advance,

Howard.

--
Howard Coakley
e-mail... howard<dot}coakleyatcoakley<dot].codotuk
Skype ID: howie10 (get skype from www.skype.com)