How do I convert an integer number to a 24-hour hh:mm time format using existing syntax?

How do I convert an integer number to a hh:mm time format using existing VBA Excel syntax? For example, 900 = 09:00 and 2100 = 21:00, 930 = 09:30, 2130 = 21:30. In other words, I don't want AM/PM stuff (I want the 24-hour system).

Any help in getting the (preferably one-liner) syntax to do this would be greatly appreciated!

In vba:

Please Login or Register  to view this content.

where stemp holds the original value

In formula

Please Login or Register  to view this content.

Sorry for the late reply but, could you also tell me how to do the opposite? That is, to convert a 24-hour time to an integer as expressed in my first post.

Yes,
In Excel formula giving text outputwith leading zero

Please Login or Register  to view this content.

and if you want a number for efficient math

Please Login or Register  to view this content.

See image attachedtimes integers.JPG

Similarly with VB but VB uses VAL() rather than VALUE()