Convert Hours and Minutes From Separate Columns Into Time

Hello,

I'm working with data (in the primary worksheet) that has the hours in one column and the minutes in the next column, for example 12 in the hours column and 10 in the minutes column refers to 12:10. I want to create a macro to fill in a table on the second worksheet and display as 12:10 in one cell. Can you help me with this?

Thanks, Manu

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)

---