time format (hour)

Patrick Stoeckli

Hi Philipp,

When using the format 'Time' or 'Custom' in TextFormat the printed result is the format string such as 'H:mm' or 'hh:mm' depending on which fomat you chose.

I am printing an UDF (date/time)/(hour).

Thank you and kind regards,
Patrick

Philipp Knecht

Hi Patrick

Try it with custom and "HH:MM".

hth

Patrick Stoeckli

Hi Philipp,

I have already tried it but it does not work.

It was an answer you gave once.

Kind regards,
Patrick

Philipp Knecht

Hi Patrick

Ah i got it now. The time part is saved as decimal number.
So the solution is custom and "00:00"

hth

Patrick Stoeckli

Hi Philipp

Thank you it worked!

Kind regards,
Patrick