Display Hour and Minutes

Question

I got two fields in my table which is Hour and Minutes. How do I display it to my report that will look like this format HH:MM?

Answer 1

Try this below formula.

ToText(datetime field, "hh:mm")