convert a number into time format

[Whooo]

I have a long integer field that I would like to convert to a short time field.

the field is called start and it contains starting times such as 830 or 2300

I have tried several different steps with no luck. THanks for suggestions Cogito ergo sum - I think?

 

[gol4]

Im sure there is an easir way but?

?format(left(cstr(830),len(cstr(830))-2) & ":" & right(cstr(830),2),"hh:nn am/pm&quot
08:30 am

you would use

=format(left(cstr(start),len(cstr(start))-2) & ":" & right(cstr(start),2),"hh:nn am/pm&quot

 

[Whooo]

thanks for your help it takes care of the formatting, Cogito ergo sum - I think?