VBA Convesion of Decimal Time Values to Formatted Text

I am using these two lines of code of populate a couple columns in my database with time values.

Please Login or Register  to view this content.

They are being populated as decimal values, rather than the h:mm am/pm format preferred.

Since I will be using these values in strings at a later time, what would I need to add to convert these decimal values to a textual format of h:mm am/pm.

Thanks in advance.

Thank you Richard for your suggestion ...

The data source is now formatted at a time (hh:mm am/pm) rather than it's decimal equivalent.
I'm having great difficulty however with integrating the "format" into my vba formula.

Please Login or Register  to view this content.

eg staff.range ("D16") = 8:00 AM, staff.range ("D16") = 8:00 AM, staff.range ("E16") = 1:00 PM,Result for range("K5") "8:00A - 1:00P"

I'm receiving a Type mismatch error.

Jenn