Can i use IFERROR with INT for time?

[ssmith04]

i have a date and time column (formatted as so) for data input. this has then been split to two columns, date, and time, using the INT function. however, its entering time as 00/01/1900, and the date as 00:00:00 even when there is no data in the input cell. When i try to use the IFERROR function in front { =IFERROR(INT(Cell Ref) } it still adds the standard base date and time as above. i want it to remain blank. im clearly missing something with a gap in my knowledge.

Any help please?

 

[RoryA]

INT returns 0, not an error, for a blank cell, which is why IFERROR won't help. Just test for blanks - e.g.:

=IF(cellref="","",int(cellref))