Avatar of bfuchs
Flag for United States of America

asked on 

How to convert two numbers into date format

Hi Experts,

I have two numbers fields, Shift_From_Hour and Shift_From_Minute
They store hours and minutes.

How do I display them in "01:45 PM" format, taking in consideration that the minutes field can be null or zero, which in that case it should be 00.

In addition if both are null or the hour field is null, it should just be be blank.
Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon