Forum Discussion
Formating hours and minutes into 24 hour
HI,
I am trying to format hours : 7:00PM with the formula =TEXT(A5,"[hh]:mm"), which will display the hour into : 19:00 (24 hour format). However, I have the 'minute' part of the data in another column of cell and was not able to merge that into part of the time displayed.
To illustrate what it looks on excel:
A B
7:00 PM 35
8:00 PM 45
I would like to merge the above data (column A as hour and column B as minutes) into a 24 hour format, such that in a new column using a formula, it will display 19:35 and 20:45 respectively. Is there any formula can help me do so? Thank you so much.
Wing hei la,
try this:
=TEXT(A5+B5/60/24,"[hh]:mm")
