Hello,
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.
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.