I have this line of code in which I am trying to convert a userform textbox (text) timne value to an actual time value.

In my example, me.uf9a_tb_cstart = "7:00 am". This code has a result of 0:00, not the 7:00 expected.

.Cells(trow, cfnd + 1) = Format(CDate(Me.uf9a_tb_cstart.Value), "0:00")
I also used CLng and had similar results.

Can anyone suggest the proper route I should be taking to resolve this?