Convert a numeric field to Text field

[tamer64]

Hello! I have a numeric field [Hours] in a table (52, 51, 50, 49...). I need to convert that to a text field to like this: 52:00:00 AM, 51:00:00 AM and so on

Any ideas on how to do this?

Thank you in advance for assistance you can provide!

 

[tamer64]

Correction to the output. I actually need to convert 52:00 and so on.

 

[tamer64]

Cancel the the call for help! Format(Right(CStr([Hours]),Len(CStr([Hours]))+2) & ":" & Right(CStr("00"),2),"Short Time")