create an excel formula with contitions

[cuvi]

I am trying to create a formula that will show contents of a cell from
another page in a workbook. The conditions are if the cell has times in it,
show the times but if it has nothing remain blank.

[GerryK]

Put this in Sheet 1 A1
=IF(ISNUMBER(Sheet2!A1),Sheet2!A1,"-- ")
Sheet 2 A1 has your time (eg. 1:30) then format Sheet1 A1
as Time, result will be 1:30:00 AM.

>-----Original Message-----
>I am trying to create a formula that will show contents
of a cell from
>another page in a workbook. The conditions are if the
cell has times in it,
>show the times but if it has nothing remain blank.
>.
>