This is my format in the calculated formula:
=TEXT([Column2]-[Column1];"hh:mm:ss")
I have value "2018-12-13 10:10:23" in Column1
but when Column2
is blank the calculated column shows "10:10:23" based of Column1
.
Is there anyway to make it blank or say some text instead?
Tried this code in calculated column but with no success:
=IF(ISBLANK([Column2]);"no value";)=TEXT([Column2]-[Column1];"hh:mm:ss")