Not sure where I am going wrong here, but I am trying to convert times in a Google Sheet from 12-hour format, e.g. 02:15:00 pm, to 24-hour format 14:15:00. I have tried several different formulas and/or selected the format from Googles formatting time options. Numerous sites provide this simple formula in Column D =TEXT(C4,"[hh]:mm:ss") but that won’t convert.
Please see the sample sheet:
https://docs.google.com/spreadsheets/d/15ae7fjKiDFW5_38nn9MOWCzptqkEaM9AcOznGnkPFzI/edit?usp=sharing
Would really appreciate some help.
>Solution :
First convert your date/time text data to pure date/time value. Then apply any format you desire. Try-
=ArrayFormula(TEXT(TIMEVALUE(SUBSTITUTE(A3:A5,".","")),"HH:MM:SS"))
Or you can use cell formatting to display correct date/time format.
