I have got a sheet that has 3 columns.

A - Code (801,802, 803, 0, " ")
B - Time (14:00:01... )
C - formula

I want C to look @ A establish which code is present and if 801/2/3 etc
return time from B. However, if code is 0 I want C to return time from
B but the issue arrises if A has a space it returns the time from B.

How can I get it to return a space/- if col A is a space and not a
code.

Thanks


--
tom300181
------------------------------------------------------------------------
tom300181's Profile: http://www.excelforum.com/member.php...o&userid=21580
View this thread: http://www.excelforum.com/showthread...hreadid=380011