how to format time from HH:MM:SS to HHMM in excel?
excel, excel-formula
Solution
If for your eyes only:
select whole column, right click somewhere in your selection, go to Format Cells, tab Number, Catergory Custom.
Type HHmm
Press OK
done.
If you need this as the actual value:
make a column containing the following formula `=TEXT(<targetcell>;"HHmm")`
Note that it is language-dependant whether you need a , or ; in that formula.
Problem
I have an excel sheet in which one of the column is transaction time and its format is HH:MM:SS. But I need transaction time in HHMM format so that i can upload that excel sheet into my application. As of now i am manually formatting each row, is there any way i can apply required format to whole column at once?