D
donny
How do I modify the following formula to also include IF
J101 also has value "ORT". I want both "", and "ORT" and
I'm having trouble getting it to work.
=IF(J101="","",DATE(MID(J101,5,4),LEFT(J101,2),MID
(J101,3,2))+TIME(MID(J101,10,2),RIGHT(J101,2),0))
J101 also has value "ORT". I want both "", and "ORT" and
I'm having trouble getting it to work.
=IF(J101="","",DATE(MID(J101,5,4),LEFT(J101,2),MID
(J101,3,2))+TIME(MID(J101,10,2),RIGHT(J101,2),0))