How to strip date from date/time in any column?You can use a simple Time formulas as shown in the image above =TIME(HOUR(A1),MINUTE(A1),SECOND(A1)) #Time