how convert number to time

[Luke_Killer_IT]

hello  i have problem I want see time  but i see number;

I used code

= Interval( V_SendungKopf.uCW_AbfahrtZeit/24/60,'hh:mm')

but i see this:

this time is wrong it should be 05:15

[tresesco · Accepted solution]

Try like:

=Time(Time#(V_SendungKopf.uCW_AbfahrtZeit ,'hhmm'),'hh:mm')

[Luke_Killer_IT]

thank for your help