Hi All,
I have a formula to change text entered time ("10:00am") to time format as below, is there a short form of this?
=IF(ISNUMBER(SEARCH("am",T2))=TRUE,TIMEVALUE(SUBSTITUTE(T2,"am"," am")),IF(ISNUMBER(SEARCH("pm",T2))=TRUE,TIMEVALUE(SUBSTITUTE(T2,"pm"," pm"))))
I have a formula to change text entered time ("10:00am") to time format as below, is there a short form of this?
=IF(ISNUMBER(SEARCH("am",T2))=TRUE,TIMEVALUE(SUBSTITUTE(T2,"am"," am")),IF(ISNUMBER(SEARCH("pm",T2))=TRUE,TIMEVALUE(SUBSTITUTE(T2,"pm"," pm"))))