Harold Garcia
Board Regular
- Joined
- Jan 2, 2014
- Messages
- 72
<colgroup><col width="89"></colgroup><tbody> </tbody> |
<colgroup><col width="103"></colgroup><tbody> </tbody> | ||
¦18:46 ¦ |
<colgroup><col width="103"></colgroup><tbody> </tbody> | ||
¦ ¦ |
<colgroup><col width="103"></colgroup><tbody> </tbody> | ||
____________ |
<colgroup><col width="103"></colgroup><tbody> </tbody> | ||
<colgroup><col width="103"></colgroup><tbody> </tbody> |
<colgroup><col width="103"></colgroup><tbody> </tbody> |
<tbody>
</tbody>
this is the original formula
=TIMEVALUE(SUBSTITUTE(A1,"¦",""))
Problem is when i drag the data it put #VALUE...
I need to return the Day-Off ¦ as D-Off
and the no data as blank...