suppose that your hour is in cell C1 and Minute in B1
type this formula (with format cell as h:mm AM/PM)
=TIME(C1,0,0)+TIME(,B1,0)
Type: Posts; User: salim hasan
suppose that your hour is in cell C1 and Minute in B1
type this formula (with format cell as h:mm AM/PM)
=TIME(C1,0,0)+TIME(,B1,0)
Enter the formula:
=LEFT(E2,3)&RIGHT(E2,3) ,replace E2 with the cell when the text is on