time format hhmm - without ":"

[fraank]

Hi there!

this might be a stupid question, but I have no idea how to solve that problem.

I need a field that will handle time in the format hhmm and convert it to hh:mm.

Is there a quick way to solve that ?

Thanks for your help

[sky]

One way would be to define a new calculation field (with result of type 'Time') with the formula:

Time ( Left ( input ; 2 ) ; Right ( input ; 2 ) ; 0 )

Sky

[comment]

You can also set the time field to auto-enter a calculated value.