I am trying to format a number as text using the TEXT function. The problem I have is I want to format it in the following way (the brackets are just notes by the way!):

[h] (a number in hours) "h" (the letter "h"): mm (a number in minutes) m (the letter "m")

The desired result would be 12h:30m.

However, the TEXT function treats the "h" and "m" as numbers, so the above example would be:

1212:3030

Does anyone know the correct syntax to acheive this?

Thanks in advance.

PS

I need to use the TEXT function and not just custom number formats.