suppose that your hour is in cell C1 and Minute in B1
type this formula (with format cell as h:mm AM/PM)
HTML Code:=TIME(C1,0,0)+TIME(,B1,0)
suppose that your hour is in cell C1 and Minute in B1
type this formula (with format cell as h:mm AM/PM)
HTML Code:=TIME(C1,0,0)+TIME(,B1,0)
Bookmarks